Mysql参考手册

23.1.9. INFORMATION_SCHEMA CHARACTER_SETS表

CHARACTER_SETS（字符集）表提供了关于可用字符集的信息。

标准名称

SHOW名称

注释

CHARACTER_SET_NAME

Charset

 

DEFAULT_COLLATE_NAME

Default collation

 

DESCRIPION

Description

MySQL扩展

MAXLEN

Maxlen

MySQL扩展

注释：

·         我们增加了两个非标准列，分别对应于SHOW CHARACTER SET输出的Description（描述）和Maxlen（最大长度）列。

下述语句是等效的：

SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS
  [WHERE name LIKE 'wild']
 
SHOW CHARACTER SET
  [LIKE 'wild']
相关文章
mysql information schema character sets表mysql information schema collation character set applicability表mysql information schema collations表mysql information schema column privileges表mysql information schema columns表mysql information schema表mysql information schema信息数据库mysql information schema key column usage表mysql 其他information schema表mysql information schema routines表mysql information schema schema privileges表mysql information schema schemata表mysql information schema statistics表mysql information schema table constraints表mysql information schema table privileges表mysql information schema tables表mysql information schema triggers表mysql information schema user privileges表mysql information schema views表php mysql xdevapi schema get schema name
关注编程学问公众号