array limit of 255

[wacook]

MSSQL, PHP, and an array limit of 255
I have searched high and low for this....and most threads regarding this are a few years old. SO...I will bring it up again, and see if there is an update or fix.

I am using MSSQL 2000 and PHP 4.3.1. I can put data in the database in unlimited lengths, but when I try to get them back out, I am limited to 255 characters. I am using mssql_query and mssql_fetch_array. Is there a fix? Update? Suggestions? Ideas?

Thanks!

[laserlight]

It could be that you are using the wrong datatype.

[j_miguel_y]

For each column in your table, do you know the character lengths you allowed for example

name varchar(255)

??

[wacook]

The character type for the field I am having trouble with is varchar 800.

[devinemke]

not sure about MSSQL, but in mySQL you cannot use varchar to store 800 characters, 255 is the limit. try using data type TEXT instead.