|
Posted by David Haynes on 09/26/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-
Navigation:
[Reply to this message]
|