On Mon, 29 Oct 2001, Jindo Soul wrote:
Why this error exists is beyond my knowledge though.
I am guessing that Perl DBI escapes ' \ in bind_param call.
And MySQL escapes the data again when using big5 charset,
which ultimate causes an error because of double escaping.
Well, its not that
Hi, Jeremy
Thanks for your response. I got the following message
while running perl script.
-- output --
processing DCP_0260.JPG
size=148135
DBD::mysql::st execute failed: You have an error in
your SQL syntax near '9ÿ\0
¨Ý¦»;ßÈïÓõ,EÂ~9íÒ¬(9àJS~PÃve Ï®G`Z¾NÒXã;ã\0çúÓºwéÓQtWîCÏ'
at line 1 at
as to
why you have problems inserting binary data into MySQL
when it's running using big5 as charset.
Regards,
Jindo
-Original Message-
From: Vincent Chen [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 28, 2001 3:52 PM
To: [EMAIL PROTECTED]
Subject: Re: insert BLOB in perl
Hi
On Sat, Oct 27, 2001 at 09:08:40PM -0700, Vincent Chen wrote:
Dear all,
It might be a FAQ, but bothered me several days. I tried to insert
a BLOB,acturally a picture, into a table. but always got SQL error.
But you haven't told us the error message you're getting!
Have you