help for PHP fetch data from mssql

[Anon]

Hi,

I had a problem using PHP to read data from SQL server 2000 database. Suppose I run "select content from books where name='aa'", I can only read the first 255 characters of the value of content. The rest of the value can not be displayed. But there is no problem with writing value with length longer than 255 back to db. Any suggestion will be appreciated. Thanks.

QQ

[Anon]

I'm not sure if this will help.

Did you have the field type for aa, a varchar, or char? If you do, the maximum is 255 (to the best of my knowledge). You could try setting the field type to text.

I use mySQL and using field type as text, i have no problem outputting more than 255 chars. Hope this helps.