freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
using sqsh to fetch an IMAGE column,
Chris Wesley, 07/25/2002
- <Possible follow-up(s)>
- Re: using sqsh to fetch an IMAGE column, Brian Bruns, 07/25/2002
- Re: using sqsh to fetch an IMAGE column, Chris Wesley, 07/26/2002
Archive powered by MHonArc 2.6.24.