[freetds] Data-conversion resulted in overflow on image column
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
I¹m using perl on Mac OS X (Tiger), with the DBD::Sybase module, and freetds
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.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.
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.833230 ct_res_info(): Number of columns is 1
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.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