PHP mySql Actionscript ' "

Question

I am trying to insert couple of words in mySql database via php with flash interface. Since the words are in foreign language some of the letters are typed as ' and ". When I try to insert these letters I get error from mySql/php.

Can letter(symbols) like mentioned above be inserted in mySql? If yes, what changes do I need to make (Actionscript, PHP, mySql). The data type in mySql is varChar.

Answer 1

Try escaping them with a backslash (\). Replace ' with \' and " with \"

Answer 2

In your mysql query use this function - http://www.php.net/manual/en/function.mysql-real-escape-string.php.

Answer 3

Use mysqli_real_escape_string (or mysql_real_escape_string).