Ubuntu
mysql-dfsg-5.1 package

  1. Bug #34181
  2. Comment #14

Comment 14 for bug 34181

Revision history for this message
Emmet Hikory (persia) wrote : Re: locale and charset problem in mysql

That patch will work well for new installs, but /etc/mysql/my.cnf is registered as a conffile, and so will not automatically be updated on upgrade (without user interaction). It is probably additionally worth adding a note to README.Debian or NEWS.Debian indicating that existing users will need to appropriately modify the conffile to take advantage of this fix.

Furthermore, there seem to be two issues in the bug report, firstly that the databases are not created in UTF8, and secondly that the localisation data in /usr/share/mysql/$language/errmsg.sys are not in utf8. Is this automatically fixed by this patch? I'm not able to replicate for ja_JP.UTF-8, as the strings appear not to be translated (or at least all my test errors resulted in English error messages).