Mysql insert encoding issue

Question

I am trying to insert Utf-8 string in a cell with utf8_general_ci collation

My code:

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

 print mb_detect_encoding($name);
 $query = "INSERT INTO items SET name='$name', type='$type'";
 print $query;
 mysql_set_charset('utf8'); // also doesn't help
 $result0 = mysql_query("SET CHARACTER SET utf8") or die(mysql_error()); // I've added this line, but it doesn't solve the issue
 $result01 = mysql_query('SET NAMES utf8') or die("set character ".mysql_error()); // still nothing
 $result = mysql_query($query) or die(mysql_error());

What I see in the html output:

UTF-8 INSERT INTO waypoints SET name='ČAS', type='ts'

What I see in the database, as name in the inserted row:

?AS

Now my string is utf-8, my table and cell is utf-8 .. why the wrong encoding?

How do you "see it in the database"? Maybe it is just an encoding problem of your tool. — Sirko
– Sirko, Commented Jul 4, 2013 at 12:09
phpmyadmin.. anyway I've tried select and print, it is stil ?AS — Oriesok Vlassky
– Oriesok Vlassky, Commented Jul 4, 2013 at 12:09
You see wrong encoding in html, but what is html encoding, is it UTF-8 ? — Kamen Stoykov
– Kamen Stoykov, Commented Jul 4, 2013 at 12:10
Here's my reference article when it comes to UTF-8 in webapps : kunststube.net/frontback — Laurent S.
– Laurent S., Commented Jul 4, 2013 at 12:12

Oriesok Vlassky · Accepted Answer · 2013-07-04 12:48:41Z

3

Ok guys, thank you all for help, it looks like I've solved the issue with:

 mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $link);

right after creating the connection

(especially @Bartdude for the article, which gave me a hint)

edited Jul 4, 2013 at 12:48

answered Jul 4, 2013 at 12:39

Oriesok Vlassky

7972 gold badges13 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Mysql insert encoding issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related