Skip to Content.
Sympa Menu

freetds - Re: maximum string length

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Geoff Winkless" <geoff AT farmline.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: maximum string length
  • Date: Fri, 4 Feb 2000 15:41:17 -0000


"Michael Suedkamp" <ms AT suedkm.franken.de> writes:
> sorry if this a FAQ. I recently got TreeTDS to work with PHP and MS SQL
> Server. My question is: Is there a limitation in the string length a query
> can return? The field I query is varchar(4000) but PHP returns only the
> first about 250 characters. It looks a little like 255 ie a Byte.

TDS4.2 (and any less than 7 (?)) defines the max length of a varchar as 255
characters.

If you want to return longer strings you must use version 7 of tds. Which is
still in development (although you can try it ;-)

Geoff





Archive powered by MHonArc 2.6.24.

Top of Page