Skip to Content.
Sympa Menu

freetds - [freetds] Data-conversion resulted in overflow on image column

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: John Gilmore-Baldwin <jbaldwin AT theolympian.com>
  • To: <FreeTDS AT lists.ibiblio.org>
  • Subject: [freetds] Data-conversion resulted in overflow on image column
  • Date: Tue, 04 Apr 2006 23:56:13 -0800

I¹m trying to extract the contents of a column of type image in a SQL 2000
server. But it is giving me the above stated error and I¹m hoping somebody
can tell me a nice, easy way to correct the problem.

I¹ve seen messages about UNIQUE IDENTIFIER not being recognized, but didn¹t
see much about image columns.

I¹m specifying a specific row, and requesting only the column that contains
the ³image² data. Really it¹s a document file. It could be a pretty large
document.

I¹m using perl on Mac OS X (Tiger), with the DBD::Sybase module, and freetds
0.63

Here¹s a log dump. This is what precedes the data, which takes up way too
much space to attach here. There are no errors that I see, though.

23:47:24.832734 processing result tokens. marker is 81(TDS7_RESULT)
23:47:24.832934 tds_free_all_results()
23:47:24.832983 processing TDS7 result. set current_results to tds->res_info
23:47:24.833017 tds_get_string: reading 36 from wire to give 18 to client.
23:47:24.833054 tds_get_string: reading 6 from wire to give 3 to client.
23:47:24.833083 tds7_get_data_info:1558:
colname = doc (3 bytes)
type = 34 (image)
server's type = 34 (image)
column_varint_size = 4
column_size = 64512 (64512 on server)
23:47:24.833119 ct_results() process_result_tokens returned 1 (type 4049)
23:47:24.833149 processing result tokens. marker is d1(ROW)
23:47:24.833176 ct_results() process_result_tokens returned 1 (type 4040)
23:47:24.833205 ct_res_info()
23:47:24.833230 ct_res_info(): Number of columns is 1
23:47:24.833261 ct_describe()
23:47:24.833288 _ct_get_client_type(type 34, user 0, size 64512)
23:47:24.833314 ct_describe() datafmt->datatype = 11 server type 34
23:47:24.833373 ct_bind() datafmt count = 1 column_number = 1
23:47:24.833498 ct_fetch()
23:47:24.833539 processing row tokens. marker is d1(ROW)
23:47:24.833568 processing row. column is 0 varint size = 4
23:47:24.833595 processing row. column size is 64512
23:47:24.833620 clearing column 0 NULL bit
23:47:24.855376 Received header





Archive powered by MHonArc 2.6.24.

Top of Page