How to properly save non english character into MySQL database using PHP?

Question

I am working on parsing a HTML of website and saving information to database but in the website, there are Non English character (like Chinese, Indian, Korean, etc) that should be saved into MySQL. My problem is that in MySQL (when i view those information using PHP MyAdmin), it displays weird characters.

Ä°lginÃ§ GerÃ§ekler
ê³µì—°ì •ë³´ PARTI(ì—°ê·¹,ì½˜ì„œíŠ¸,ë®¤ì§€ì»¬,ì˜¤í...
ì •ì‹ ì—°ë ¹ í…ŒìŠ¤íŠ¸

How to properly save these information to database?

score 4 · Accepted Answer · answered Jul 05 '12 at 14:04

4

try using

mysql_query("SET NAMES 'UTF8'");

after mysql_connect or mysql_select_db. I use that for Turkish mysql_query("SET NAMES 'latin5'");

answered Jul 05 '12 at 14:04

koala12

56
2

score 0 · Answer 2 · answered Jul 05 '12 at 14:00

0

First of all make sure that the Table and Row Encoding is UTF-8 Formated. Next you should save the PHP Script file as UTF-8 Encoded With or Without BOM.

Or you can try using htmlspecialchars(); function to do that.

answered Jul 05 '12 at 14:00

Rosmarine Popcorn

10,761
11
59
89

score 0 · Answer 3 · answered Jul 05 '12 at 14:01

0

You must convert your insertion and/or tables to another coding style. Here you are how: http://dev.mysql.com/doc/refman/5.0/en/charset-convert.html

answered Jul 05 '12 at 14:01

elvenbyte

776
1
17
34

score 0 · Answer 4 · edited May 23 '17 at 11:53

0

change your table collation to utf8

$con=mysql_connect("hostname","username","password");

mysql_query("SET CHARACTER SET utf8",$con);

check also this post

edited May 23 '17 at 11:53

Community

1
1

answered Jul 05 '12 at 14:31

Alireza

1,428
4
21
33

How to properly save non english character into MySQL database using PHP?

4 Answers4

Linked