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

binmode(FILE);
$fdata=read(FILE,$filelength);

[download]

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.

In reply to dbd:Sybase bit scramble by CaptainDaddy

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.