You should not need to escape french characters. Try this test
script:
Just use 'cut and paste' to paste eash line into the command line
interface and you will see it works fine.
use test;
create table français (
id int unsigned auto_increment primary key,
text char(60)
);
insert français (text) values ('crée français');
select * from français;
Si tu parle français bien et tu veux que je t'aide donner moi un coup
direct à [EMAIL PROTECTED] et je t'aiderai.
Ken
-----------------------------------------------------
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
----- Original Message -----
From: "christopher sagayam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 12:15 PM
Subject: how to escape french characters
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
---------------------------------------------------------------------
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