Skip to Content.
Sympa Menu

freetds - Re: mssql ntext format

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: mssql ntext format
  • Date: Tue, 8 Jan 2002 21:36:44 -0500 (EST)


By the way this can also be set in the freetds.conf file using the 'text
size' directive. Example:

[myserver]
host =
tds version = 7.0
text size = 4906

This way programs need not be modified, and it can be done on a per server
basis.

Brian

On Tue, 8 Jan 2002, James K. Lowden wrote:

> 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
>
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>






Archive powered by MHonArc 2.6.24.

Top of Page