This is a bugger to figure out - basically I was using php to read a varchar value in a SQL database. Problem was, my returning value was cut off at around 255 or 256 characters. Even changing the mssql.textlimit and mssql.textsize values in the php.ini file didn’t help. The answer, it seems, is to preform a little conversation in your SQL SELECT statement:

select *, convert(text,bio) as bio from writers

So if “bio” is the field that is in the SQL database than contains more than 256 characters, the above should give you ALL those characters back.

Related posts

• Storing an IP Address in MySQL (0)
• Simplest PHP Framework? (0)
• Simple PHP Currency Converter (0)
• AJAX Based PHP5 MVC Framework (0)
• Writing Secure PHP (0)