Recently I've had trouble putting files larger than a certain size (around 3kb) into a sql server. I've been using unixODBC, DBD:ODBC, and FreeTDS.
I've noticed that a similar issue was posted on CPAN as a bug for the latest DBC:ODBC, and didn't understand the fix that the poster found.
I recently switched from DBD:ODBC to DBD:Sybase, and after what I felt was an unnescessary use of CONVERT (see my thread 'dbd odbc sql big file blues') I could insert very large varbinaries.
However when I try to insert real files using this method I get a warning that there is an error converting characters and the files get stomped on. This seems odd to me since I use
before I bind the data for insert. I'd like to use a solution with freeTDS for obvious reasons; it was suggested that I use the easysoft driver in the above mentioned thread and I will try that with dbd:odbc and post the results there, but this seems a problem separate from freeTDS. I'll be grateful for any help in this.