SHOW COLLATION

SHOW COLLATION 语句用于提供一个静态的排序规则列表，确保与 MySQL 客户端库的兼容性。

注意: TiDB 目前仅支持二进制排序规则。

语法图

ShowStmt:

ShowStmt

ShowTargetFilterable:

ShowTargetFilterable

示例

  1. mysql> SHOW COLLATION;
  2. +--------------------------+----------+------+---------+----------+---------+
  3. | Collation                | Charset  | Id   | Default | Compiled | Sortlen |
  4. +--------------------------+----------+------+---------+----------+---------+
  5. | big5_chinese_ci          | big5     |    1 | Yes     | Yes      |       1 |
  6. | latin2_czech_cs          | latin2   |    2 |         | Yes      |       1 |
  7. | dec8_swedish_ci          | dec8     |    3 | Yes     | Yes      |       1 |
  8. | cp850_general_ci         | cp850    |    4 | Yes     | Yes      |       1 |
  9. | latin1_german1_ci        | latin1   |    5 |         | Yes      |       1 |
  10. | hp8_english_ci           | hp8      |    6 | Yes     | Yes      |       1 |
  11. | koi8r_general_ci         | koi8r    |    7 | Yes     | Yes      |       1 |
  12. | latin1_swedish_ci        | latin1   |    8 | Yes     | Yes      |       1 |
  13. | latin2_general_ci        | latin2   |    9 | Yes     | Yes      |       1 |
  14. | swe7_swedish_ci          | swe7     |   10 | Yes     | Yes      |       1 |
  15. | ascii_general_ci         | ascii    |   11 | Yes     | Yes      |       1 |
  16. | ujis_japanese_ci         | ujis     |   12 | Yes     | Yes      |       1 |
  17. | sjis_japanese_ci         | sjis     |   13 | Yes     | Yes      |       1 |
  18. | cp1251_bulgarian_ci      | cp1251   |   14 |         | Yes      |       1 |
  19. | latin1_danish_ci         | latin1   |   15 |         | Yes      |       1 |
  20. | hebrew_general_ci        | hebrew   |   16 | Yes     | Yes      |       1 |
  21. | tis620_thai_ci           | tis620   |   18 | Yes     | Yes      |       1 |
  22. | euckr_korean_ci          | euckr    |   19 | Yes     | Yes      |       1 |
  23. | latin7_estonian_cs       | latin7   |   20 |         | Yes      |       1 |
  24. | latin2_hungarian_ci      | latin2   |   21 |         | Yes      |       1 |
  25. | koi8u_general_ci         | koi8u    |   22 | Yes     | Yes      |       1 |
  26. | cp1251_ukrainian_ci      | cp1251   |   23 |         | Yes      |       1 |
  27. | gb2312_chinese_ci        | gb2312   |   24 | Yes     | Yes      |       1 |
  28. | greek_general_ci         | greek    |   25 | Yes     | Yes      |       1 |
  29. | cp1250_general_ci        | cp1250   |   26 | Yes     | Yes      |       1 |
  30. | latin2_croatian_ci       | latin2   |   27 |         | Yes      |       1 |
  31. | gbk_chinese_ci           | gbk      |   28 | Yes     | Yes      |       1 |
  32. | cp1257_lithuanian_ci     | cp1257   |   29 |         | Yes      |       1 |
  33. | latin5_turkish_ci        | latin5   |   30 | Yes     | Yes      |       1 |
  34. | latin1_german2_ci        | latin1   |   31 |         | Yes      |       1 |
  35. | armscii8_general_ci      | armscii8 |   32 | Yes     | Yes      |       1 |
  36. | utf8_general_ci          | utf8     |   33 | Yes     | Yes      |       1 |
  37. | cp1250_czech_cs          | cp1250   |   34 |         | Yes      |       1 |
  38. | ucs2_general_ci          | ucs2     |   35 | Yes     | Yes      |       1 |
  39. | cp866_general_ci         | cp866    |   36 | Yes     | Yes      |       1 |
  40. | keybcs2_general_ci       | keybcs2  |   37 | Yes     | Yes      |       1 |
  41. | macce_general_ci         | macce    |   38 | Yes     | Yes      |       1 |
  42. | macroman_general_ci      | macroman |   39 | Yes     | Yes      |       1 |
  43. | cp852_general_ci         | cp852    |   40 | Yes     | Yes      |       1 |
  44. | latin7_general_ci        | latin7   |   41 | Yes     | Yes      |       1 |
  45. | latin7_general_cs        | latin7   |   42 |         | Yes      |       1 |
  46. | macce_bin                | macce    |   43 |         | Yes      |       1 |
  47. | cp1250_croatian_ci       | cp1250   |   44 |         | Yes      |       1 |
  48. | utf8mb4_general_ci       | utf8mb4  |   45 | Yes     | Yes      |       1 |
  49. | utf8mb4_bin              | utf8mb4  |   46 |         | Yes      |       1 |
  50. | latin1_bin               | latin1   |   47 |         | Yes      |       1 |
  51. | latin1_general_ci        | latin1   |   48 |         | Yes      |       1 |
  52. | latin1_general_cs        | latin1   |   49 |         | Yes      |       1 |
  53. | cp1251_bin               | cp1251   |   50 |         | Yes      |       1 |
  54. | cp1251_general_ci        | cp1251   |   51 | Yes     | Yes      |       1 |
  55. | cp1251_general_cs        | cp1251   |   52 |         | Yes      |       1 |
  56. | macroman_bin             | macroman |   53 |         | Yes      |       1 |
  57. | utf16_general_ci         | utf16    |   54 | Yes     | Yes      |       1 |
  58. | utf16_bin                | utf16    |   55 |         | Yes      |       1 |
  59. | utf16le_general_ci       | utf16le  |   56 | Yes     | Yes      |       1 |
  60. | cp1256_general_ci        | cp1256   |   57 | Yes     | Yes      |       1 |
  61. | cp1257_bin               | cp1257   |   58 |         | Yes      |       1 |
  62. | cp1257_general_ci        | cp1257   |   59 | Yes     | Yes      |       1 |
  63. | utf32_general_ci         | utf32    |   60 | Yes     | Yes      |       1 |
  64. | utf32_bin                | utf32    |   61 |         | Yes      |       1 |
  65. | utf16le_bin              | utf16le  |   62 |         | Yes      |       1 |
  66. | binary                   | binary   |   63 | Yes     | Yes      |       1 |
  67. | armscii8_bin             | armscii8 |   64 |         | Yes      |       1 |
  68. | ascii_bin                | ascii    |   65 |         | Yes      |       1 |
  69. | cp1250_bin               | cp1250   |   66 |         | Yes      |       1 |
  70. | cp1256_bin               | cp1256   |   67 |         | Yes      |       1 |
  71. | cp866_bin                | cp866    |   68 |         | Yes      |       1 |
  72. | dec8_bin                 | dec8     |   69 |         | Yes      |       1 |
  73. | greek_bin                | greek    |   70 |         | Yes      |       1 |
  74. | hebrew_bin               | hebrew   |   71 |         | Yes      |       1 |
  75. | hp8_bin                  | hp8      |   72 |         | Yes      |       1 |
  76. | keybcs2_bin              | keybcs2  |   73 |         | Yes      |       1 |
  77. | koi8r_bin                | koi8r    |   74 |         | Yes      |       1 |
  78. | koi8u_bin                | koi8u    |   75 |         | Yes      |       1 |
  79. | latin2_bin               | latin2   |   77 |         | Yes      |       1 |
  80. | latin5_bin               | latin5   |   78 |         | Yes      |       1 |
  81. | latin7_bin               | latin7   |   79 |         | Yes      |       1 |
  82. | cp850_bin                | cp850    |   80 |         | Yes      |       1 |
  83. | cp852_bin                | cp852    |   81 |         | Yes      |       1 |
  84. | swe7_bin                 | swe7     |   82 |         | Yes      |       1 |
  85. | utf8_bin                 | utf8     |   83 |         | Yes      |       1 |
  86. | big5_bin                 | big5     |   84 |         | Yes      |       1 |
  87. | euckr_bin                | euckr    |   85 |         | Yes      |       1 |
  88. | gb2312_bin               | gb2312   |   86 |         | Yes      |       1 |
  89. | gbk_bin                  | gbk      |   87 |         | Yes      |       1 |
  90. | sjis_bin                 | sjis     |   88 |         | Yes      |       1 |
  91. | tis620_bin               | tis620   |   89 |         | Yes      |       1 |
  92. | ucs2_bin                 | ucs2     |   90 |         | Yes      |       1 |
  93. | ujis_bin                 | ujis     |   91 |         | Yes      |       1 |
  94. | geostd8_general_ci       | geostd8  |   92 | Yes     | Yes      |       1 |
  95. | geostd8_bin              | geostd8  |   93 |         | Yes      |       1 |
  96. | latin1_spanish_ci        | latin1   |   94 |         | Yes      |       1 |
  97. | cp932_japanese_ci        | cp932    |   95 | Yes     | Yes      |       1 |
  98. | cp932_bin                | cp932    |   96 |         | Yes      |       1 |
  99. | eucjpms_japanese_ci      | eucjpms  |   97 | Yes     | Yes      |       1 |
  100. | eucjpms_bin              | eucjpms  |   98 |         | Yes      |       1 |
  101. | cp1250_polish_ci         | cp1250   |   99 |         | Yes      |       1 |
  102. | utf16_unicode_ci         | utf16    |  101 |         | Yes      |       1 |
  103. | utf16_icelandic_ci       | utf16    |  102 |         | Yes      |       1 |
  104. | utf16_latvian_ci         | utf16    |  103 |         | Yes      |       1 |
  105. | utf16_romanian_ci        | utf16    |  104 |         | Yes      |       1 |
  106. | utf16_slovenian_ci       | utf16    |  105 |         | Yes      |       1 |
  107. | utf16_polish_ci          | utf16    |  106 |         | Yes      |       1 |
  108. | utf16_estonian_ci        | utf16    |  107 |         | Yes      |       1 |
  109. | utf16_spanish_ci         | utf16    |  108 |         | Yes      |       1 |
  110. | utf16_swedish_ci         | utf16    |  109 |         | Yes      |       1 |
  111. | utf16_turkish_ci         | utf16    |  110 |         | Yes      |       1 |
  112. | utf16_czech_ci           | utf16    |  111 |         | Yes      |       1 |
  113. | utf16_danish_ci          | utf16    |  112 |         | Yes      |       1 |
  114. | utf16_lithuanian_ci      | utf16    |  113 |         | Yes      |       1 |
  115. | utf16_slovak_ci          | utf16    |  114 |         | Yes      |       1 |
  116. | utf16_spanish2_ci        | utf16    |  115 |         | Yes      |       1 |
  117. | utf16_roman_ci           | utf16    |  116 |         | Yes      |       1 |
  118. | utf16_persian_ci         | utf16    |  117 |         | Yes      |       1 |
  119. | utf16_esperanto_ci       | utf16    |  118 |         | Yes      |       1 |
  120. | utf16_hungarian_ci       | utf16    |  119 |         | Yes      |       1 |
  121. | utf16_sinhala_ci         | utf16    |  120 |         | Yes      |       1 |
  122. | utf16_german2_ci         | utf16    |  121 |         | Yes      |       1 |
  123. | utf16_croatian_ci        | utf16    |  122 |         | Yes      |       1 |
  124. | utf16_unicode_520_ci     | utf16    |  123 |         | Yes      |       1 |
  125. | utf16_vietnamese_ci      | utf16    |  124 |         | Yes      |       1 |
  126. | ucs2_unicode_ci          | ucs2     |  128 |         | Yes      |       1 |
  127. | ucs2_icelandic_ci        | ucs2     |  129 |         | Yes      |       1 |
  128. | ucs2_latvian_ci          | ucs2     |  130 |         | Yes      |       1 |
  129. | ucs2_romanian_ci         | ucs2     |  131 |         | Yes      |       1 |
  130. | ucs2_slovenian_ci        | ucs2     |  132 |         | Yes      |       1 |
  131. | ucs2_polish_ci           | ucs2     |  133 |         | Yes      |       1 |
  132. | ucs2_estonian_ci         | ucs2     |  134 |         | Yes      |       1 |
  133. | ucs2_spanish_ci          | ucs2     |  135 |         | Yes      |       1 |
  134. | ucs2_swedish_ci          | ucs2     |  136 |         | Yes      |       1 |
  135. | ucs2_turkish_ci          | ucs2     |  137 |         | Yes      |       1 |
  136. | ucs2_czech_ci            | ucs2     |  138 |         | Yes      |       1 |
  137. | ucs2_danish_ci           | ucs2     |  139 |         | Yes      |       1 |
  138. | ucs2_lithuanian_ci       | ucs2     |  140 |         | Yes      |       1 |
  139. | ucs2_slovak_ci           | ucs2     |  141 |         | Yes      |       1 |
  140. | ucs2_spanish2_ci         | ucs2     |  142 |         | Yes      |       1 |
  141. | ucs2_roman_ci            | ucs2     |  143 |         | Yes      |       1 |
  142. | ucs2_persian_ci          | ucs2     |  144 |         | Yes      |       1 |
  143. | ucs2_esperanto_ci        | ucs2     |  145 |         | Yes      |       1 |
  144. | ucs2_hungarian_ci        | ucs2     |  146 |         | Yes      |       1 |
  145. | ucs2_sinhala_ci          | ucs2     |  147 |         | Yes      |       1 |
  146. | ucs2_german2_ci          | ucs2     |  148 |         | Yes      |       1 |
  147. | ucs2_croatian_ci         | ucs2     |  149 |         | Yes      |       1 |
  148. | ucs2_unicode_520_ci      | ucs2     |  150 |         | Yes      |       1 |
  149. | ucs2_vietnamese_ci       | ucs2     |  151 |         | Yes      |       1 |
  150. | ucs2_general_mysql500_ci | ucs2     |  159 |         | Yes      |       1 |
  151. | utf32_unicode_ci         | utf32    |  160 |         | Yes      |       1 |
  152. | utf32_icelandic_ci       | utf32    |  161 |         | Yes      |       1 |
  153. | utf32_latvian_ci         | utf32    |  162 |         | Yes      |       1 |
  154. | utf32_romanian_ci        | utf32    |  163 |         | Yes      |       1 |
  155. | utf32_slovenian_ci       | utf32    |  164 |         | Yes      |       1 |
  156. | utf32_polish_ci          | utf32    |  165 |         | Yes      |       1 |
  157. | utf32_estonian_ci        | utf32    |  166 |         | Yes      |       1 |
  158. | utf32_spanish_ci         | utf32    |  167 |         | Yes      |       1 |
  159. | utf32_swedish_ci         | utf32    |  168 |         | Yes      |       1 |
  160. | utf32_turkish_ci         | utf32    |  169 |         | Yes      |       1 |
  161. | utf32_czech_ci           | utf32    |  170 |         | Yes      |       1 |
  162. | utf32_danish_ci          | utf32    |  171 |         | Yes      |       1 |
  163. | utf32_lithuanian_ci      | utf32    |  172 |         | Yes      |       1 |
  164. | utf32_slovak_ci          | utf32    |  173 |         | Yes      |       1 |
  165. | utf32_spanish2_ci        | utf32    |  174 |         | Yes      |       1 |
  166. | utf32_roman_ci           | utf32    |  175 |         | Yes      |       1 |
  167. | utf32_persian_ci         | utf32    |  176 |         | Yes      |       1 |
  168. | utf32_esperanto_ci       | utf32    |  177 |         | Yes      |       1 |
  169. | utf32_hungarian_ci       | utf32    |  178 |         | Yes      |       1 |
  170. | utf32_sinhala_ci         | utf32    |  179 |         | Yes      |       1 |
  171. | utf32_german2_ci         | utf32    |  180 |         | Yes      |       1 |
  172. | utf32_croatian_ci        | utf32    |  181 |         | Yes      |       1 |
  173. | utf32_unicode_520_ci     | utf32    |  182 |         | Yes      |       1 |
  174. | utf32_vietnamese_ci      | utf32    |  183 |         | Yes      |       1 |
  175. | utf8_unicode_ci          | utf8     |  192 |         | Yes      |       1 |
  176. | utf8_icelandic_ci        | utf8     |  193 |         | Yes      |       1 |
  177. | utf8_latvian_ci          | utf8     |  194 |         | Yes      |       1 |
  178. | utf8_romanian_ci         | utf8     |  195 |         | Yes      |       1 |
  179. | utf8_slovenian_ci        | utf8     |  196 |         | Yes      |       1 |
  180. | utf8_polish_ci           | utf8     |  197 |         | Yes      |       1 |
  181. | utf8_estonian_ci         | utf8     |  198 |         | Yes      |       1 |
  182. | utf8_spanish_ci          | utf8     |  199 |         | Yes      |       1 |
  183. | utf8_swedish_ci          | utf8     |  200 |         | Yes      |       1 |
  184. | utf8_turkish_ci          | utf8     |  201 |         | Yes      |       1 |
  185. | utf8_czech_ci            | utf8     |  202 |         | Yes      |       1 |
  186. | utf8_danish_ci           | utf8     |  203 |         | Yes      |       1 |
  187. | utf8_lithuanian_ci       | utf8     |  204 |         | Yes      |       1 |
  188. | utf8_slovak_ci           | utf8     |  205 |         | Yes      |       1 |
  189. | utf8_spanish2_ci         | utf8     |  206 |         | Yes      |       1 |
  190. | utf8_roman_ci            | utf8     |  207 |         | Yes      |       1 |
  191. | utf8_persian_ci          | utf8     |  208 |         | Yes      |       1 |
  192. | utf8_esperanto_ci        | utf8     |  209 |         | Yes      |       1 |
  193. | utf8_hungarian_ci        | utf8     |  210 |         | Yes      |       1 |
  194. | utf8_sinhala_ci          | utf8     |  211 |         | Yes      |       1 |
  195. | utf8_german2_ci          | utf8     |  212 |         | Yes      |       1 |
  196. | utf8_croatian_ci         | utf8     |  213 |         | Yes      |       1 |
  197. | utf8_unicode_520_ci      | utf8     |  214 |         | Yes      |       1 |
  198. | utf8_vietnamese_ci       | utf8     |  215 |         | Yes      |       1 |
  199. | utf8_general_mysql500_ci | utf8     |  223 |         | Yes      |       1 |
  200. | utf8mb4_unicode_ci       | utf8mb4  |  224 |         | Yes      |       1 |
  201. | utf8mb4_icelandic_ci     | utf8mb4  |  225 |         | Yes      |       1 |
  202. | utf8mb4_latvian_ci       | utf8mb4  |  226 |         | Yes      |       1 |
  203. | utf8mb4_romanian_ci      | utf8mb4  |  227 |         | Yes      |       1 |
  204. | utf8mb4_slovenian_ci     | utf8mb4  |  228 |         | Yes      |       1 |
  205. | utf8mb4_polish_ci        | utf8mb4  |  229 |         | Yes      |       1 |
  206. | utf8mb4_estonian_ci      | utf8mb4  |  230 |         | Yes      |       1 |
  207. | utf8mb4_spanish_ci       | utf8mb4  |  231 |         | Yes      |       1 |
  208. | utf8mb4_swedish_ci       | utf8mb4  |  232 |         | Yes      |       1 |
  209. | utf8mb4_turkish_ci       | utf8mb4  |  233 |         | Yes      |       1 |
  210. | utf8mb4_czech_ci         | utf8mb4  |  234 |         | Yes      |       1 |
  211. | utf8mb4_danish_ci        | utf8mb4  |  235 |         | Yes      |       1 |
  212. | utf8mb4_lithuanian_ci    | utf8mb4  |  236 |         | Yes      |       1 |
  213. | utf8mb4_slovak_ci        | utf8mb4  |  237 |         | Yes      |       1 |
  214. | utf8mb4_spanish2_ci      | utf8mb4  |  238 |         | Yes      |       1 |
  215. | utf8mb4_roman_ci         | utf8mb4  |  239 |         | Yes      |       1 |
  216. | utf8mb4_persian_ci       | utf8mb4  |  240 |         | Yes      |       1 |
  217. | utf8mb4_esperanto_ci     | utf8mb4  |  241 |         | Yes      |       1 |
  218. | utf8mb4_hungarian_ci     | utf8mb4  |  242 |         | Yes      |       1 |
  219. | utf8mb4_sinhala_ci       | utf8mb4  |  243 |         | Yes      |       1 |
  220. | utf8mb4_german2_ci       | utf8mb4  |  244 |         | Yes      |       1 |
  221. | utf8mb4_croatian_ci      | utf8mb4  |  245 |         | Yes      |       1 |
  222. | utf8mb4_unicode_520_ci   | utf8mb4  |  246 |         | Yes      |       1 |
  223. | utf8mb4_vietnamese_ci    | utf8mb4  |  247 |         | Yes      |       1 |
  224. +--------------------------+----------+------+---------+----------+---------+
  225. 219 rows in set (0.00 sec)

MySQL 兼容性

TiDB 不支持二进制以外的排序规则。SHOW COLLATION 语句仅用于确保与 MySQL 的兼容性。

另请参阅