Modify MySQL Character Set

MySQL Character Set modification command

1. modify server level. temporary changes: mysql> set global character_set_server = utf8; B. permanent change: shell> VI/etc/My. CNF [mysqld] default-character-set = utf8

2. modify Database Level A. Temporary changes: mysql> set global character_set_database = utf8; B. permanent changes: changed the server level.

3. Modify the table-level mysql> alter table table_name default charset utf8; the change takes effect permanently.

4. example of modifying a column-level modification: mysql> alter table 'products' change 'products _ model' varchar (20) Character Set utf8 collate utf8_general_ci null default null; the change takes effect permanently. change the connection Character Set. temporary changes: mysql> set names utf8; B. permanent change: shell> VI/etc/My. CNF added in [client]: default-character-set = utf8