maximum string length

Michael Südkamp ms at suedkm.franken.de
Sun Feb 6 14:44:14 EST 2000


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




More information about the FreeTDS mailing list