Mysql - CHARACTER and COLLATION

 

 

Doc 1 :   Case Sensitivity in String Searches    &     Case Sensitive collation in MySQL

 

Doc 2 :  Chinese document 与查询有关的事宜     &     字符集支持

 

Doc 3 : Using COLLATE in SQL Statements      &    SHOW Syntax

 

Doc 4 : ALTER TABLE COLLATION     &   Stackoverflow - MySql alter table Collation 

 

 Take a Look : How do I see what character set a database / table / column is in MySQL?

 

 

---

  

显示Mysql所有编码:

show character set; 

 

创建时指定数据库编码

create database <DataBase_Name> character set utf8 collate utf8_bin;

 

修改指定数据库编码

alter database <DataBase_Name> character set utf8 collate utf8_bin;

　　

 

---

  

设置Mysql Databases编码:

 

show variables like 'character%';

SET character_set_client = utf8 ; (For all databases) 

SET character_set_connection = utf8 ; (For all databases) 

SET character_set_database = utf8 ; (For all databases) 

SET character_set_results = utf8 ; (For all databases) 

SET character_set_server = utf8 ; (For all databases) 

SET character_set_system = utf8 ; (For all databases) 

show variables like 'character%';

 

 

---

 

设置Mysql Table编码: 

show create table <table_name>;

ALTER TABLE <table_name> CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;

  

 

 

 

 

To see the specified table's collation:

SHOW FULL COLUMNS FROM <table_name>; -- or (show create table <table_name>;)

　　 

To see the database collations :

show variables like "character%";

show variables like "collation%";