FreeTDS Development Group

["Joe McDonald" <joe AT vpop.net>]

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')
>