Skip to Content.
Sympa Menu

freetds - Re: using sqsh to fetch an IMAGE column

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.metalab.unc.edu>
  • Subject: Re: using sqsh to fetch an IMAGE column
  • Date: Thu, 25 Jul 2002 23:01:52 -0400 (EDT)


You need to set the text size using either the "set textsize = xxxxx"
command or modify your freetds.conf to include the "text size = xxxx"
option. MS SQL defaults to 4096 by default.

Brian

On Thu, 25 Jul 2002, Chris Wesley wrote:

> I have sqsh (2.1) working fine with freetds (0.53) to query an SQL2000
> server. However when I try to retrieve a an IMAGE column, I only get the
> first 4K of the data. If I have TDSDUMP logged to a file, I can see the
> whole 'transaction' happen, including this at the end:
>
> <all the stuff you expect to see>
> <the hex data from the IMAGE column>
>
> 2002-07-25 13:54:47 inside _ct_bind_data()
> 2002-07-25 13:54:47 inside _ct_get_server_type()
> 2002-07-25 13:54:47 inside _ct_bind_data() converting column 0 from type
> 34 to type 34
> 2002-07-25 13:54:47 inside _ct_bind_data() setting source length for 0 =
> 4096
> 2002-07-25 13:54:47 inside _ct_bind_data() conversion done len = 4096
> bindfmt = 0
> 2002-07-25 13:54:47 inside _ct_bind_data() length binding len = 4096
> 2002-07-25 13:54:47 inside _ct_get_server_type()
> 2002-07-25 13:54:47 inside _ct_get_server_type()
> 2002-07-25 13:54:47 inside ct_fetch()
> 2002-07-25 13:54:47 processing row tokens. marker is fd
> 2002-07-25 13:54:47 inside ct_results()
> 2002-07-25 13:54:47 inside ct_res_info()
> 2002-07-25 13:54:47 inside ct_results()
> 2002-07-25 13:54:47 inside ct_cmd_drop()
> 2002-07-25 13:54:47 inside ct_con_props() action = CS_GET property = 26
> 2002-07-25 13:54:47 inside ct_close()
> 2002-07-25 13:54:47 inside ct_con_drop()
> 2002-07-25 13:54:47 inside ct_exit()
>
> ... that's the end.
> Am I correct in suspecting that these two lines contain the information
> that is of concern to me? :
> 2002-07-25 13:54:47 inside _ct_bind_data() conversion done len = 4096
> bindfmt = 0
> 2002-07-25 13:54:47 inside _ct_bind_data() length binding len = 4096
>
> If so, what IS the information here, and is there anything I can do to
> increase the length of retrieved data on an IMAGE column?
>
> Thanks for any help,
> ~Chris
>
> ---
> 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