SqlServer text size limitation
bisho at eurielec.etsit.upm.es
Fri Mar 30 05:39:05 EST 2001
>The TDS 4.2 protocol is limited to a 1 byte size field for varchar fields
>(thus 255 characters max). Using TDS 7.0 will allow you to see the fields
>without them being truncated.
>On Thu, 29 Mar 2001, Rodolphe Ode wrote:
>> Hi !
>> I got a trouble with SQLServer that I query with PHP (Linux) through FreeTDS. Actually, I got some bunch of text fields (VARCHAR) that may contain up to 4000 character, but as I select this fields in an SQL query, only the first 255 characters are given back to PHP. Is there anyone who has/had the same trouble ?
I have another problem. Using text fields and protocol version 7.0 and SQL
Server 7.0 SP3 it says that the server gives a erroneous response.
The protocol 4.2 connect and return queries, but the text fields are returned
without the last character.
I'm using FreeTDS 0.51.
Is a known issue??? Is there any patch???
\|||||||/ Guillermo Pérez Pérez
< o o > - bisho at onirica.com
\ L / - bisho at eurielec.etsit.upm.es
Onírica: Análisis, diseño e implantación de soluciones informáticas
More information about the FreeTDS