FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

Hmmm...you may need to issue a 'set textsize 4000' or some such prior to
issuing your query...I don't know the default textsize for MS SQL off the
top of my head.

Brian

On Sun, 6 Feb 2000, Michael [iso-8859-1] S?dkamp wrote:

> Brian Bruns wrote:
> 
> >
> > Option #2 is to convert them to 'text' during the select...(that is:
> > 'select convert(text,mynvarcharcol) from atable') this will work under all
> > version of TDS.
> >
> 
> Thanks to everyone who responded !
> 
> Brian, that sounded promising. I executed "select conv=convert(text, mycol) 
> from
> mytable" and retrieved the value for conv but it returned still only a 
> length of 254
> characters. Did I something wrong?
> 
> Best regards
> 
> Michael
>