default character set should be set to utf8
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-dfsg-5.0 (Ubuntu) |
New
|
Medium
|
Unassigned |
Bug Description
At least since version 4.1 MySQL supports character sets and encodings in the right way, i.e. the client can tell the server which character set he uses (CHARACTER_
As Ubuntu uses utf8 as default - and MySQL uses latin1 as default, the current situation leads to the problem that the mysql command line utility as well as mysqldump connect to the server with charset latin1. So this leads to wrong character set conversions (i.e. no character set conversions are done, although they should have been done)
In my opinion the solution is to add default-
BUT: I think a lot of people have arranged with the old (and in my optionion - wrong - )conversion behaviour - so such a change should be considered careful...
(Checked on last Ubuntu Dapper Flight 6)
Now after one year, I can confirm that this problem still exists in feisty. I have to force every database I create to use default character set utf-8. I just don't understand why this cannot be set as the default of the server in /etc/mysql/my.cnf .