4 messages in com.mysql.lists.perlRe: Insert binary data into Blob data...
FromSent OnAttachments
Patrick Fong07 Feb 2001 08:44 
Jochen Wiedmann07 Feb 2001 11:45 
Patrick Fong07 Feb 2001 17:38 
Dodger08 Feb 2001 08:08 
Subject:Re: Insert binary data into Blob data type
From:Patrick Fong (scf@nevigator.com)
Date:02/07/2001 05:38:53 PM
List:com.mysql.lists.perl

Dear all,

No error message. Just some garbage characters as shown in below.

DBI::db=HASH(0x81c666c) trace level set to 2 in DBI 1.14-nothread Note: perl is running without the recommended perl -w option -> prepare for DBD::mysql::db (DBI::db=HASH(0x81c675c)~0x81c666c 'insert into binaryfile v lues (?)') Setting mysql_use_result to 0 <- prepare= DBI::st=HASH(0x817acb4) at test.pl line 21. -> execute for DBD::mysql::st (DBI::st=HASH(0x817acb4)~0x81c7af4 'GIF89ad.< ...... You have an error in your SQL syntax near 'Xow3 .....

Note: I'm using the lastest MySql, DBI, and DBD. The attachment is the file I try to insert into database

Thanks a lot. Thanks a lot.

Yours sincerely, Patrick Fong

On Wed, 7 Feb 2001, Jochen Wiedmann wrote:

Quoting Patrick Fong <scf@netvigator.com>:

The program failed when executing $sth-execute($dataStr). Why?

What error message?