inserting special character to mysql

Question

INSERT INTO `tablecity` (`City`, `Country`) VALUES('胡志明市', 'Vietnam');

City become e883a1e5bf97e6988ee5b882

What's wrong?

In some other databases this works fine. In the one I am working with I have this problem.

Does each table in mysql has their own encoding?

Standard response: probably the connection encoding. Check How to handle Unicode. — deceze
– deceze ♦, Commented Mar 19, 2012 at 10:52

Straseus · Accepted Answer · 2012-03-19 10:57:51Z

1

Does each table in mysql has their own encoding?

Yes. And each field as well.

answered Mar 19, 2012 at 10:57

Straseus

4781 gold badge4 silver badges14 bronze badges

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

Comments

Prateek Sharma · Accepted Answer · 2012-03-19 11:19:39Z

0

answered Mar 19, 2012 at 11:19

Prateek Sharma

3463 silver badges12 bronze badges

user4951 · Accepted Answer · 2012-03-30 05:37:30Z

0

We figured out the problem. The database, based on collation think that it's best to display e883a1e5bf97e6988ee5b882 if collation is binary.

What's actually inside the database is correct.

And yes we can change how it's displayed in phpmyadmin but there is no way to set that as default. The default is set by system administrator.

answered Mar 30, 2012 at 5:37

user4951

33.3k55 gold badges182 silver badges289 bronze badges