1. Edit the/etc/my. cnf file and add "default-character-set = utf8" under "[client"
2. Edit the/etc/my. cnf file and add "default-character-set = utf8" under "[mysqld"
3. Restart the mysql service.
# Sudo/etc/init. d/mysqld restart
* View the system character set and sorting method
- Mysql> SHOW VARIABLES LIKE'Collation \ _ %';
- + -------------------------- + -------- +
- | Variable_name | Value |
- + -------------------------- + -------- +
- | Character_set_client | utf8 |
- | Character_set_connection | utf8 |
- | Character_set_database | utf8 |
- | Character_set_filesystem | binary |
- | Character_set_results | utf8 |
- | Character_set_server | utf8 |
- | Character_set_system | utf8 |
- + -------------------------- + -------- +
- Mysql> SHOW VARIABLES LIKE'Character \ _ set \ _ %';
- + ---------------------- + ----------------- +
- | Variable_name | Value |
- + ---------------------- + ----------------- +
- | Collation_connection | utf8_general_ci |
- | Collation_database | utf8_bin |
- | Collation_server | utf8_general_ci |
- + ---------------------- + ----------------- +
4. Set the database Character Set
Mysql> create database <database> default character set utf8 default collate utf8_bin;
Or modify an existing database.
Mysql> alter database <database> default character set utf8 default collate utf8_bin;
* View all COLLATION supported by mysql
Mysql> show collation;