Ubuntu
mysql-dfsg-5.1 package

  1. Bug #34181
  2. Comment #15

Comment 15 for bug 34181

Revision history for this message
Alan Tam (at) wrote : Re: locale and charset problem in mysql

Emmet,

MySQL defines a lot of variables for character sets:
mysql> show variables;
+---------------------------------+---------------------------------+
| Variable_name | Value |
 +---------------------------------+---------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
 +---------------------------------+---------------------------------+

Does it help if you switch all of them to utf8?

I prefer forking this issue into another bug, since it is a localization issue, rather than the internationalization issue that most comments are about.