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

John Gilmore-Baldwin jbaldwin at theolympian.com
Wed Apr 5 03:56:13 EDT 2006


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



More information about the FreeTDS mailing list