freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
SqlServer text size limitation,
Rodolphe Ode, 03/29/2001
- <Possible follow-up(s)>
- RE: SqlServer text size limitation, Sasha Dolgy, 03/29/2001
- RE: SqlServer text size limitation, Bob Kline, 03/29/2001
- Re: SqlServer text size limitation, Brian Bruns, 03/29/2001
- Re: SqlServer text size limitation, Guille -bisho-, 03/30/2001
- Re: SqlServer text size limitation, Eric Deutsch, 03/30/2001
Archive powered by MHonArc 2.6.24.