FreeTDS Development Group

[Stephen More <mores AT yahoo.com>]

I am having trouble with binary columns....

I have attached a perl script that reads in the freetds logo, then inserts 
into MSSQL70 Database.

Here is my output:

bash-2.03$ ./debug.pl 
Length of Logo: 5442 at ./debug.pl line 28, <LOGO> line 39.
error_handler: Data-conversion resulted in overflow.
error_handler: Data-conversion resulted in overflow.
error_handler: Data-conversion resulted in overflow.


In order for the insert to work I had to remove all NULLS and quote the 
quotes.
DB: MS SQL Server 7.0
Solaris 2.8
perl, v5.6.1 
DBD-Sybase-0.94
DBI-1.30
freetds-0.60


Would it be possible for someone to make this example work, then perhaps add 
it to:
http://www.freetds.org/userguide/x1488.htm


-Thanks
Stephen More


>On Point 4. Normal operations with text/image/binary columns should function
>fine, at least as far as FreeTDS is concerned. I can't speak for Perl, but I
>can't recall anything to suggest that there are problems in this area.


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

Attachment: debug.pl
Description: debug.pl