Encoding PHP/MySQL

Question

I wrote a PHP file which should insert values in a MySQL database.

I explain my problem with an example.

include 'db_connect.php';
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");
$title = 'knödel';
echo $title;
$sql="INSERT INTO RECIPES (title) VALUES ('$title')";

In the database, there is 'kn';

I cut the string from the umlaut.

What is the character encoding *of the table*? Both the connection charset (which you've set) *and* the table charset should be set to the same value. — Piskvor left the building, Jan 20 '12 at 08:00
related: http://stackoverflow.com/questions/4363020/how-do-i-get-rid-of-unrecognized-characters-in-utf-8-mysql-php/4363842#4363842 — Roman, Jan 20 '12 at 08:18
I found my mistake... I need to define a encoding in html, where I calling the php-file. Thanks for your help.... — user959456, Jan 20 '12 at 08:25
OK. Go back and [**accept** the useful answers](http://stackoverflow.com/faq#howtoask) to your previous questions. You might want to add your solution as an answer to your question and accept it too. — Hossein, Jan 20 '12 at 09:11

score 1 · Accepted Answer · edited May 23 '17 at 12:23

If your database collation is Unicode or UTF-8, just do:

$sql="INSERT INTO RECIPES (title) VALUES (N'$title')";

The only difference is the N character which makes it possible to insert Unicode data into the database.

And you have to take the security risks seriously. Use mysql_real_escape_string together with other required actions to protect against sql injections. (If you don't do it now, you'll forget it when writing a big real-world application.)

Encoding PHP/MySQL

1 Answers1