Posted by David Haynes on 11/18/50 11:44

Mark Knochen wrote:
> Hallo,
>
> i have a MS SQL Database with some tables with textfields.
> in the textfields are long strings ... but i cant get the full string
> from the table ... i get only ca. 8000 chars ...
>
> Mark
MSSQL has an 8000 character limit for varchar.
NOTE: the driver used by PHP only supports 255 characters in a varchar.

text (the data type not the type of data) has a limit of 2^31-1 bytes.

So, you need to store the value as text not varchar. You can probably
use CONVERT to move from varchar to text.

-david-

[Back to original message]