There is a function in the dbi called quote...
$dbh->quote($somethign1);
Look it up:
http://ep33.tp4.ruhr-uni-bochum.de/mlists/MySQL/May.2000/3018.html
At 09:45 PM 4/11/2001 +0530, christopher sagayam wrote:
>im using a INSERT into tablename values ('$something1' , '$something2')
>
>now if $something1 contains any french characters like é
>
>mysql says there is an error in sql statement
>
>I am using a BLOB datatype
>
>How to escape french characters using perl or using mysql
>
>
>chris
---------------------------------------------------------------------
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"It has been said that the primary function of schools is to impart enough
facts to make children stop asking questions. Some, with whom the schools
do not succeed, become scientists." - Knut Schmidt-Nielson
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
