Skip to Content.
Sympa Menu

freetds - Re: problems with large columns

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Joe McDonald" <joe AT vpop.net>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: problems with large columns
  • Date: Thu, 23 Sep 1999 10:22:16 -0700



Thanks for the info Brian. Yes, this is a large varchar. I tried
converting, but it gave me an error:

1> select convert(text,content) from newsletter
2> go
Unknown marker: 0!!

Any ideas what that's about?

Thanks,
-joe


> -----Original Message-----
> From: bounce-freetds-95718 AT franklin.oit.unc.edu
> [mailto:bounce-freetds-95718 AT franklin.oit.unc.edu]On Behalf Of Brian
> Bruns
> Sent: Thursday, September 23, 1999 4:58 AM
> To: TDS Development Group
> Subject: [freetds] Re: problems with large columns
>
>
>
> It depends. Are these text fields or large varchar fields? Large varchar
> is only supported in TDS 7.0 which is not really implemented yet (there is
> some code in for the login packet but much more needs to be done). TDS 4.2
> by definition will not handle it. However, text fields should work, so a
> work around would be to convert them to text during the select, such as:
>
> select convert(text,largecol1) from table1
>
> Hope this helps,
>
> Brian
>
> On Thu, 23 Sep 1999, Joe McDonald wrote:
>
> > Hello,
> >
> > I am using freetds to access an MS-sql server. When I try to
> access columns
> > that are larger than 256 characters, I only get the first 256
> characters.
> >
> > Is there a work around for this? I notice that it gets the column-size
> > with tds_get_byte(), since it is only getting 1 byte, I can see why the
> > max column_size reported is 255, I'm hoping there is a way around this.
> >
> > Thanks,
> > -joe
> >
> >
> > ---
> > You are currently subscribed to freetds as: camber AT ais.org
> > To unsubscribe, forward this message to
> $subst('Email.Unsub')
> >
> >
>
>
> ---
> You are currently subscribed to freetds as: joe AT vpop.net
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>





Archive powered by MHonArc 2.6.24.

Top of Page