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: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: SqlServer text size limitation
  • Date: Thu, 29 Mar 2001 18:17:14 -0500 (EST)


Hi,

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 ?
>
> Thanks a lot,
>
> Rodolphe
>





Archive powered by MHonArc 2.6.24.

Top of Page