FreeTDS Development Group

["Geoff Winkless" <geoff AT farmline.com>]

"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