Skip to Content.
Sympa Menu

freetds - using sqsh to fetch an IMAGE column

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Chris Wesley" <cwwesley AT udlug.org>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: using sqsh to fetch an IMAGE column
  • Date: Thu, 25 Jul 2002 17:17:59 -0400


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




Archive powered by MHonArc 2.6.24.

Top of Page