how to escape french characters

[christopher sagayam]

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