in reply to Inserting an PDF to SqlServer using Perl

A PDF file can potentially contain any nasty char, including quotes etc., so it's not a good idea to interpolate that binary data into the SQL query... (I'm assuming your $pdf_file[0] is holding the file's contents, not the filename).

Have you tried using placeholders instead? I.e. put pdf = ? in the query, and then pass the data using $sth->execute($pdf_data)

Replies are listed 'Best First'.
Re^2: Inserting an PDF to SqlServer using Perl
by Anonymous Monk on Jul 02, 2007 at 21:40 UTC
    Yes, it holds the file's content, not just the file name.