FreeTDS Development Group

["Eric Deutsch" <edeutsch AT systemsbiology.org>]

Hi all, I tried to store some large binary objects in an IMAGE column
and couldn't get it to work (Linux x86 + Perl + DBD::Sybase + MS SQL
Server 2000 via TDS 7.0).  I think there have been some other threads
previous to this but it's not clear that anyone has been successful at
this.

It turned out to be a fairly simple fix.  Essentially all I had to do
was add a case for SYBTEXT in tds_convert_binary() and repair the
hexification part which was suffering from sign problems.  Obviously,
this has TEXTSIZE limitations, but in my test I was able to store and
retrieve a 283k JPEG image after a 'SET TEXTSIZE 512000'.

I'd like to suggest it squeak into 0.60, but I realize it's the 11th
hour.  This patch also includes the much-discussed TEXT truncation fix.

Thanks,
Eric


----------------------------------------------------------------------
Eric Deutsch                        email: edeutsch AT systemsbiology.org
Institute for Systems Biology                    Voice: (206) 732-1397
1441 N 34th St                                     FAX: (206) 732-1260
Seattle, WA  98103-8904                 http://www.systemsbiology.org/

Attachment: convert.patch
Description: Binary data