Using Chinese characters in mysql table

Question

I'm trying to use Chinese characters in mysql table. On my first try I wrote something like 中文考试 and my table came back with è¿˜æœ‰ä¸€ä¸ªè€ƒè¯•.

After research, it was suggested that I use the UTF-8 as my character set. I went back to my table and altered the character set with the command

ALTER TABLE posts CONVERT TO CHARACTER SET utf8;

I tried writing Chinese characters again and got the same result - ( è¿˜æœ‰ä¸€ä¸ªè€ƒè¯•.).

Here is a copy of my table as it exist right now:

enter image description here

How can I get my table to accept Chinese characters?

possible duplicate of How to make MySQL handle UTF-8 properly — Joe
– Joe, Commented Jun 13, 2014 at 1:54

Community · Accepted Answer · 2017-05-23 11:59:31Z

2

After research, it was suggested that I use the UTF-8 as my character set.

You need to make sure your entire chain from the connection, to the database, to the tables is all UTF8 clean. I have a detailed answer to a similar question here.

But in your case, check the actual MySQL server my.cnf file. The following would set the whole chain to UTF-8:

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

The my.cnf is the main MySQL configuration file. Depending on your OS it can be located in a few places. For example in Ubuntu 12.04 it can be found here:

/etc/mysql/my.cnf

So figure out where yours is located, open up that file, edit it, restart MySQL & you should be good to go.

edited May 23, 2017 at 11:59

CommunityBot

11 silver badge

answered Jun 13, 2014 at 1:54

Giacomo1968

25.3k11 gold badges78 silver badges106 bronze badges

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

Collectives™ on Stack Overflow

Using Chinese characters in mysql table

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