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
]]
> Sent: Sunday, October 28, 2001 3:52 PM
> To: [EMAIL PROTECTED]
> Subject: Re: insert BLOB in perl
>
>
>
> Hi, Jeremy
>
> Thanks for your response. I got the following message
> while running perl script.
>
> -- output --
> processing DCP_0260.JPG
>
>
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 .
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 double-ch
