We need more code than (SELECT... and INSERT...). How did you see the funny
unescaped character? Did you print them out, in that case did you binmode
STDOUT?
Use trace() to see exactly what is going on. Also an error message on
insert would be very helpful to us.
Ilya Sterin
-----Original Message-----
From: Yannis Livassof
To: [EMAIL PROTECTED]
Sent: 05/02/2001 3:28 AM
Subject: quoting binaries (MYSQL)
Hi!
Does anybody knows how to quote the binarie fields properly using the
DBI.pm (on Mysql)?
I used "SELECT ..." ,
then
$dnh->quote(some data),
then
$dbh->do("INSERT ...")
The last "do" leads to error.
As I see, some funny characters selected from binary fields are not
escaped. I compared it with the output generated with "mysqldump".
Plese help!!!!!
Yannis Livassov
