Jump to content

Archived

This topic is now archived and is closed to further replies.

bholbrook

PHP / MSSQL / ODBC Limits

Recommended Posts

I have a string stored in a DB that is very long. When I print it out on the page, it chops off at 4,096 characters.

Is tis a MSSQL limitation, ODBC limitation or PHP string limitation?

WIN 2003 Server
MSSQL DB
ODBC Connection through PHP

Share this post


Link to post
Share on other sites
[quote]WIN 2003 Server
MSSQL DB
ODBC Connection through PHP[/quote]
mssql sort of sucks.  Mysql would be your best bet, but if it's a huge chunk of text, use longtext type.  If it still cut's some off, then if it's temporary store it in a session, if not then you can always store an infinite amount in a file somewhere.  even if it's temporary.  But there is a huge limitation on mysql, with data type long text.  It isn't a php, or connection limitation.  You could have 50 different full length novels saved in 1 php variable.  The database however may have an upper limit, even with longtext, but a file is not limited, you can always add more to it, it just increases the bytes, taking longer to load

Share this post


Link to post
Share on other sites
Unfortunately we have no control over what database is being used, and I don't believe it is a database issue; the database field is holding the appropriate text.

I didn't think that strings had limits, and if ODBC doesn't limit it, what couold be the problem?

Does ODBC or MSSQL send the information in 4096 bit chunks and it has to be read that way?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.