SqlServer text size limitation

Guille -bisho- 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
 -oOOo-------oOOo-
 Onírica: Análisis, diseño e implantación de soluciones informáticas
          http://www.onirica.com



More information about the FreeTDS mailing list