Change the default Character Set of MySQL under Ubuntu11.10

In Ubuntu11.10, the default Character Set of MySQL is changed because I installed mysql in sudo apt-get install Mysql-server mode. By default, the mysql character set is still latin1, therefore, you must replace it with the utf8 character set. Modify/etc/mysql/my. cnf file www.2cto.com 1 sudo gedit/etc/mysql/my. after cnf is enabled, add default-character-set = utf8 under [clinet] and add default-character-set = utf8 under [mysqld]. Then restart mysql 1 sudo/etc/init. d/mysql restart. Then let's check the changed character set 1 in mysql. Open the terminal mysql-u root-p2 show variables like 'character _ set _ % '; 3 show variables like 'collation _ % '; Author: Guan lingyu