UTF-8 Charset problems

Question

Possible Duplicate:
UTF-8 all the way through

I'm trying to insert special characters (like é etc.) in a MySQL database but when I insert through a query, in the database it appears as: "Ã©". When I insert the query directly in Phpmyadmin, it works as it should. I have already set the collection charset to utf8_unicode_ci. I have this in my HTML:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

How can I fix this? (I already googled it, but I only found the collection things, that won't work..)

(jQuery because I'm sending it with a $.POST)

do you mean collation instead of collection? – WayneC Oct 21 '12 at 19:17 — WayneC, Oct 21 '12 at 19:17

score 1 · Accepted Answer · answered Oct 21 '12 at 19:16

1

Is your database connection using utf8?

Try running this sql when you initialise your db connection:

SET NAMES 'utf8';

I suggest you read through this too.

answered Oct 21 '12 at 19:16

WayneC

5,569
2
32
43

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

1

Make sure the connection to your database is also using this character set:

$conn = mysql_connect($server, $username, $password);
mysql_set_charset("UTF8", $conn);

see this answer: answer

edited May 23 '17 at 12:04

Community

1
1

answered Oct 21 '12 at 19:17

yanddam

399
2
12

score 0 · Answer 3 · answered Oct 21 '12 at 19:17

Try to do

mysqli_query('SET NAMES utf8');

after connecting to database.
According to the manual, SET NAMES indicates what character set the client will use to send SQL statements to the server. Thus, SET NAMES 'utf8' tells the server that future incoming messages from client will be in utf8 encoding. It also specifies the character set that the server should use for sending results back to the client.

UTF-8 Charset problems

3 Answers3