Skip to Content.
Sympa Menu

freetds - Re: Truncating varchar from MSSQL in FreeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Kaeptn Weltall" <rl AT w4u.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: Truncating varchar from MSSQL in FreeTDS
  • Date: Fri, 15 Mar 2002 10:51:34 -0500


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.




Archive powered by MHonArc 2.6.24.

Top of Page