-
-
Save in-78/5397630 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| below is my configure to support utf8: | |
| [client] | |
| default-character-set=utf8 | |
| [mysqld] | |
| init_connect='SET collation_connection = utf8_unicode_ci' | |
| init_connect='SET NAMES utf8' | |
| character-set-server=utf8 | |
| collation-server=utf8_unicode_ci | |
| skip-character-set-client-handshake | |
| restart mysql server after change my.cnf: | |
| sudo service mysql restart | |
| if database already exist: | |
| mysql> alter database DATABASE default character set utf8; | |
| mysql> alter database DATABASE default collate utf8_general_ci; | |
| if table already exist: | |
| mysql> alter table table_name convert to character set utf8 collate utf8_general_ci; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment