MySQL installation-free Chinese Character Set settings

MySQL Default encoding is Latin1, does not support Chinese, so how to modify the default encoding of MySQL, the following UTF-8 as an example to illustrate the need to note that, to modify a lot of places, there are also a lot of corresponding modification methods. The following is the simplest and most thorough method: 1. Windows
1. Stop the MySQL Service
2, in the installation directory of MySQL find my. ini, if not, copy the my-medium.ini as a my. ini
3. After opening my. ini, add default-character-set = utf8 under [client] and [mysqld], save and close
4. Start MySQL Service 2. Linux
1. Stop MySQL Service (bin/mysqladmin-u root shutdown)
2. Find my under/etc. CNF, if not, copy the my-medium.cnf under the support-Files directory under the MySQL installation directory to/etc/and rename it to my. CNF
3. After opening my. CNF, add default-character-set = utf8 under [client] and [mysqld], save and close
4, start MySQL Service (bin/mysqld_safe &) is very simple, this change once and for all, in the future MySQL All Related default encoding is UTF-8, when creating a new table, you do not need to set it again. Note that the existing data in the current database still retains the existing encoding method. Therefore, you need to perform transcoding on your own. There are many methods on the Internet, I will not go into details. View several commands of the database character set: Show variables like 'character \ _ set \ _ % '; show variables like 'collation _ %'; it seems that MySQL commands running on the command line do not support utf8, there seems to be nothing after insertion, so you can execute set names GBK when inserting data; then set names utf8; or use interactive tools to insert.