freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: mssql ntext format

From: "James K. Lowden" <jklowden AT speakeasy.org>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Re: mssql ntext format
Date: Tue, 08 Jan 2002 20:19:57 -0500

Stefan Carstens wrote:
>
> READ THE FAQ, YOUR ANSWER IS ALREADY THERE !

Ouch! That wasn't very nice.

> From: "Kaeptn Weltall" <rl AT w4u.com>
> Sent: Monday, January 07, 2002 3:22 PM
>
> > i have the following problem when selecting a column of ntext
> > format from an mssql2k server:
> > the script simply stops executing.
> > eg
> >
> > select ntextcol from tab
> >
> > with ntextcol of format ntext sends no answer while
> >
> > select cast(ntextcol as nvarchar(2048)) from tab
> >
> > makes no trouble.

Kaeptn,

I think Sefan is pointing you to

http://www.freetds.org/faq.html#textdata

Does the problem go away if you set @@textsize? PHP & Co. might be
choking on the MS lie about a 2 GB field.

--jkl

mssql ntext format, Kaeptn Weltall, 01/07/2002
- <Possible follow-up(s)>
- Re: mssql ntext format, Stefan Carstens, 01/07/2002
- Re: mssql ntext format, James K. Lowden, 01/08/2002
- Re: mssql ntext format, Brian Bruns, 01/08/2002
- Re: mssql ntext format, Kaeptn Weltall, 01/16/2002