Ubuntu12.04 sets the default MySQL Encoding

(1) alas, the system has been installed for a day. Although it is not enough to say that Ubuntu does not toss a few partitions, it is really time-consuming and laborious (2) Let's talk about my notebook partition, because I am mainly engaged in development under ubuntu, I have installed a dual-system. windows is mainly used to play games. Everyone knows this. The ubuntu partition plan is:/boot256M/swap8G/home120G/root50G (3) mainly in the u

(1) alas, the system has been installed for a day. Although it is not enough to say that Ubuntu does not toss a few partitions, it is time-consuming and labor-consuming.

(2) Let's talk about my notebook partition. Because I mainly develop it in ubuntu, I have installed a dual system. windows is mainly used to play games. Everyone knows, not much. The ubuntu partition plan is:/boot 256 M/swap 8G/home 120G/root 50G

(3) A bug occurred when setting mysql encoding in ubuntu12.04, which is slightly different from the previous version 11.10 and earlier versions. The difference is as follows:

The previous 10.04 configuration is as follows:

[Client]

Default-character-set = utf8

[Mysqld]

Default-character-set = utf8

However, 12.04 modified the encoding method for setting mysqld:

[Client]

Default-character-set = utf8 (ps: the client settings have not changed)

[Mysqld]

Lower_case_table_names = 1 (Case Insensitive)

Character_set_server = utf8 (ps: note the changes here)

(4) In ubuntu, the Chinese input method has always been a problem. We suggest using fcitx. ibus is not used to it.