PHP Mysqli character encoding

Question

How come that this:

$tekst = "ideeën";
$query = "UPDATE `home` SET `tekst`='" . $conn->real_escape_string($tekst) . "' WHERE `section` = 'welkom'";
mysqli_query($conn, $query) or die ("query fout " . mysqli_error($conn) );

Is stored in the database as: ideeÃ«n

your database column data type must be utf-8-bin if you want exact word to save. — Death-is-the-real-truth
– Death-is-the-real-truth, Commented May 8, 2015 at 18:22
That didn't work. Something else that may help someone come up with the solution: When I edit the text manually in PHPMyAdmin, it does work. — Stanniebeer
– Stanniebeer, Commented May 8, 2015 at 18:30
You shouldn't have to worry too much about how it appears in the database. As long as your treatment of the value going into the database and then drawing back out is the same, how it appears in your SQL client should be irrelevant. — Jerbot
– Jerbot, Commented May 8, 2015 at 18:54
I'll work with the SQL client side then if solving this seems like an issue, thanks anyways :) — Stanniebeer
– Stanniebeer, Commented May 8, 2015 at 19:03

Lexib0y · Accepted Answer · 2015-10-02 06:34:22Z

1

Have you tried changing the character set of the connection?

/* change character set to utf8 */
if (!$mysqli->set_charset("utf8")) {
    printf("Error loading character set utf8: %s\n", $mysqli->error);
    exit();
} else {
    printf("Current character set: %s\n", $mysqli->character_set_name());
}

See http://php.net/manual/en/mysqli.set-charset.php

answered Oct 2, 2015 at 6:34

Lexib0y

51011 silver badges28 bronze badges

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

1 Comment

Lexib0y Over a year ago

I had this problem in the past. At one point had to fix it because I needed to share the data with another web app, but that involved also changing the data in the database.

Collectives™ on Stack Overflow

PHP Mysqli character encoding

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related