MySQL基础：CharacterSet和Collation，Java进阶班

查看MySQL Server支持的Charset

============================

有很多种方法可以查看当前MySQL Server支持的Character Set:

show character set; – 方法1

show charset; – 方法2

show char set; – 方法3

select * from information_schema.character_sets; – 方法 4

查看特定字符集信息（主要包含默认的Collation和MAXLEN）:

show character set like ‘utf%’;; – 方法1

show charset like ‘utf%’;; – 方法2

show char set like ‘utf%’; – 方法3

select * from information_schema.character_sets

where CHARACTER_SET_NAME like ‘utf%’; – 方法 4

查看MySQL Server支持的Collation

==============================

SHOW COLLATION WHERE Charset = ‘utf8mb4’;

或者

select * from INFORMATION_SCHEMA.COLLATIONS where CHARACTER_SET_NAME=‘utf8mb4’;

查看MySQL Server当前的Charset和Collation

======================================

show variables like ‘character_set_server’;

show variables like ‘collation_server’;

或者使用语句：

select @@character_set_server, @@collation_server;