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
– Piskvor left the building, Commented Jan 20, 2012 at 8:00
OK. Go back and accept the useful answers to your previous questions. You might want to add your solution as an answer to your question and accept it too. — Hossein
– Hossein, Commented Jan 20, 2012 at 9:11

Community · Accepted Answer · 2017-05-23 12:23:39Z

1

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.)

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Jan 20, 2012 at 9:06

Hossein

4,1652 gold badges26 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Encoding PHP/MySQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related