CODEWITHSUNDEEP
mysqlencoding
user4951
user4951

Reputation: 33050

inserting special character to mysql

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?

Upvotes: 0

Views: 576

Answers (3)

user4951
user4951

Reputation: 33050

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.

Upvotes: 0

Prateek Sharma
Prateek Sharma

Reputation: 346

You can find complete documentation here http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html

Upvotes: 0

Straseus
Straseus

Reputation: 478

Does each table in mysql has their own encoding?

Yes. And each field as well.

Upvotes: 1

Related Questions