freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: maximum string length

From: Michael Südkamp <ms AT suedkm.franken.de>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Re: maximum string length
Date: Sun, 06 Feb 2000 19:44:14 +0000

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

maximum string length, Michael Suedkamp, 02/04/2000
- <Possible follow-up(s)>
- Re: maximum string length, Geoff Winkless, 02/04/2000
- Re: maximum string length, Brian Bruns, 02/04/2000
- Re: maximum string length, Brian Zhou, 02/05/2000
- Re: maximum string length, Michael Südkamp, 02/06/2000
- Re: maximum string length, Brian Bruns, 02/06/2000
- Re: maximum string length, Michael Suedkamp, 02/07/2000
- Re: maximum string length, Michael Suedkamp, 02/12/2000
- Re: maximum string length, Brian Bruns, 02/12/2000