FreeTDS Development Group

["Kaeptn Weltall" <rl AT w4u.com>]

i have had two situations:

1.
if your field is not really varchat but text,
you can influence the maximum length with

  SET TEXTSIZE <num>

this setting is connection level, you have to set
it after every connect, otherwise a default is
set. if this default or your setting is too low,
of cause truncation takes place.Then if you use php:
If TEXTSIZE is too high (about some 100M) in some
cases the php script interpreter will stop work
with no errormessage although textsize range reaches
up to 2G (2^31-1).

2.
if u use "select ... for xml .." the output will
be kind of varchar where the xml string is sent
in chunks, each in a row with one field.
but the data type is here set different, the chunks
get truncated after 255 chars, what makes them
worthless.