Skip to Content.
Sympa Menu

freetds - Re: maximum string length

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT umcc.ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: maximum string length
  • Date: Sun, 6 Feb 2000 21:38:07 -0500 (EST)


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
>





Archive powered by MHonArc 2.6.24.

Top of Page