mssql_result returning only 255 chars

[Anon]

Hey,

Got a problem with mssql and php.

I've got a field in a table containing a lot of chars (a description field).

When fetching the field with a

mssql_result($RecordSet,0,"sDescription");

it is only returning the first 255 chars ...

The field is a varchar(5000) and in the dbase the description was +2000 chars ...

Is this a PHP-bug ????

I've fixed it by altering the database field to a text and now it works ....

Has anybody else got this problem before ???

thanks in advance

[Anon]

varchar max is 255 chars

I just found that out yesterday and have had to edit my fields also 🙁

Oh well, I guess that's another lesson learned!

Nick