Skip to Content.
Sympa Menu

freetds - Re: SqlServer text size limitation

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Guille -bisho- <bisho AT eurielec.etsit.upm.es>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: SqlServer text size limitation
  • Date: Fri, 30 Mar 2001 12:39:05 +0200


>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




Archive powered by MHonArc 2.6.24.

Top of Page