PHP / MSSQL / ODBC Limits

[bholbrook]

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

[Ninjakreborn]

[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

[bholbrook]

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?