本文主要是介绍information_schema系统表——COLLATIONS，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
该表包含每个字符集的所有信息
The COLLATIONS table provides information about collations for each character set.
INFORMATION_SCHEMA Name | SHOW Name | Remarks |
|---|---|---|
COLLATION_NAME | Collation | |
CHARACTER_SET_NAME | Charset | MySQL extension |
ID | Id | MySQL extension |
IS_DEFAULT | Default | MySQL extension |
IS_COMPILED | Compiled | MySQL extension |
SORTLEN | Sortlen | MySQL extension |
-
COLLATION_NAMEis the collation name. -
CHARACTER_SET_NAMEis the name of the character set with which the collation is associated. -
IDis the collation ID. -
IS_DEFAULTindicates whether the collation is the default for its character set. -
IS_COMPILEDindicates whether the character set is compiled into the server. -
SORTLENis related to the amount of memory required to sort strings expressed in the character set.
这篇关于information_schema系统表——COLLATIONS的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
