更改mysql数据库的字符集

peacock66

操作前备份：

数据库字符集从 latin1 改成 utf8.

1. Dump the database to a text file using mysqldump tool from the command-line : 
   mysqldump -p --default_character-set=latin1 -u <username> --skip-set-charset confluence > confluence_database.sql
2. copy confluence_database.sql to confluence_utf8.sql
3. Open confluence_utf8.sql in a text editor and change all character sets from 'latin1' to 'utf8'
4. Encode all the latin1 characters as UTF-8: 
   recode latin1..utf8 confluence_utf8.sql (the recode utility is described athttp://directory.fsf.org/recode.html; it can actually be downloaded from http://recode.progiciels-bpi.ca/, and is available for Ubuntu via apt-get)

In MySQL:

1. DROP DATABASE confluence;
2. CREATE DATABASE confluence CHARACTER SET utf8 COLLATE utf8_bin;

未实践，请不要直接在线上操作