FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

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