FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

Ok, I'll take a look at it and see what I can find.

Brian

On Thu, 23 Sep 1999, Joe McDonald wrote:

> 
> Here is another tidbit of the problem:
> 1> select convert(text,content) from newsletter
> 2> go
> Unknown marker: 0!!
> 1> select a=convert(text,content) from newsletter
> 2> go
> Unknown marker: 32!!
> Unknown marker: 105!!
> Unknown marker: 115!!
> Unknown marker: 32!!
> Unknown marker: 97!!
> Unknown marker: 110!!
> Unknown marker: 32!!
> Unknown marker: 101!!
> Unknown marker: 120!!
> Unknown marker: 97!!
> Unknown marker: 109!!
> Unknown marker: 112!!
> Unknown marker: 108!!
> Unknown marker: 101!!
> Unknown marker: 32!!
> Unknown marker: 110!!
> Unknown marker: 101!!
> Unknown marker: 119!!
> Unknown marker: 115!!
> Unknown marker: 108!!
> Unknown marker: 101!!
> Unknown marker: 116!!
> Unknown marker: 116!!
> Unknown marker: 101!!
> Unknown marker: 114!!
> Unknown marker: 46!!
> Unknown marker: 66!!
> Unknown marker: 0!!
> 1>
> 
> This is on FreeBSD 2.2.8 using sqsh 1.7 and the latest freetds from CVS.
> 
> 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
> > >