Skip to Content.
Sympa Menu

freetds - Re: mssql ntext format

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.24.

Top of Page