MS SQL - Select Only returns about 250 characters

[solodesignz]

Hey..

well the subject line pretty much says it.

Simple, when I run a select statement on my DB, it will only return the first 250 characters from a text column.

I know there is a seeting in the php.ini and that is set to the max:

mssql.textlimit = 2147483647
mssql.textsize = 2147483647

But that doesnt help... is there something else anywhere that limits this?

[solodesignz]

Ok Figured it out =P

If you're having problems trying to get data stored in a varchar column with more than 255 chars use CONVERT to change the data type to TEXT like this:

$query=mssql_query("SELECT table.id, CONVERT(TEXT, table.comment) AS comment FROM table");

Don't forget to set name for the column (AS comment) or you won't be able to retrieve the data ...