Mssql/php truncation on varchar, text

[mimoun]

Hello everybody,

I am using PHP 4.3.5 with SQLServer 8 and I still get a truncation on the varchar columns after 255 chars, and 4096 on a text column !
I undestood the problem was closed, it seems not ... there is no problem to store but only when retrieving

Someone would have a solution ?

I must add I use PEAR:😃B to query the SQLServer ...

Thanks

[mimoun]

Found for the text fields, you should configure your php.ini with : mssql.textlimit = 20000 or whatever else
mssql.textsize = 20000 or whatever else

but for the varchar I am still enquiring ...

[superwormy]

VARCHAR fields have a max size limit of 255 characters. Almost every database available is the same exact way. If you have more than 255 characters to store, use an external file or a TEXT type field.