本站源代码
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

252 lines
8.2KB

  1. // Go MySQL Driver - A MySQL-Driver for Go's database/sql package
  2. //
  3. // Copyright 2014 The Go-MySQL-Driver Authors. All rights reserved.
  4. //
  5. // This Source Code Form is subject to the terms of the Mozilla Public
  6. // License, v. 2.0. If a copy of the MPL was not distributed with this file,
  7. // You can obtain one at http://mozilla.org/MPL/2.0/.
  8. package mysql
  9. const defaultCollation = "utf8_general_ci"
  10. const binaryCollation = "binary"
  11. // A list of available collations mapped to the internal ID.
  12. // To update this map use the following MySQL query:
  13. // SELECT COLLATION_NAME, ID FROM information_schema.COLLATIONS
  14. var collations = map[string]byte{
  15. "big5_chinese_ci": 1,
  16. "latin2_czech_cs": 2,
  17. "dec8_swedish_ci": 3,
  18. "cp850_general_ci": 4,
  19. "latin1_german1_ci": 5,
  20. "hp8_english_ci": 6,
  21. "koi8r_general_ci": 7,
  22. "latin1_swedish_ci": 8,
  23. "latin2_general_ci": 9,
  24. "swe7_swedish_ci": 10,
  25. "ascii_general_ci": 11,
  26. "ujis_japanese_ci": 12,
  27. "sjis_japanese_ci": 13,
  28. "cp1251_bulgarian_ci": 14,
  29. "latin1_danish_ci": 15,
  30. "hebrew_general_ci": 16,
  31. "tis620_thai_ci": 18,
  32. "euckr_korean_ci": 19,
  33. "latin7_estonian_cs": 20,
  34. "latin2_hungarian_ci": 21,
  35. "koi8u_general_ci": 22,
  36. "cp1251_ukrainian_ci": 23,
  37. "gb2312_chinese_ci": 24,
  38. "greek_general_ci": 25,
  39. "cp1250_general_ci": 26,
  40. "latin2_croatian_ci": 27,
  41. "gbk_chinese_ci": 28,
  42. "cp1257_lithuanian_ci": 29,
  43. "latin5_turkish_ci": 30,
  44. "latin1_german2_ci": 31,
  45. "armscii8_general_ci": 32,
  46. "utf8_general_ci": 33,
  47. "cp1250_czech_cs": 34,
  48. "ucs2_general_ci": 35,
  49. "cp866_general_ci": 36,
  50. "keybcs2_general_ci": 37,
  51. "macce_general_ci": 38,
  52. "macroman_general_ci": 39,
  53. "cp852_general_ci": 40,
  54. "latin7_general_ci": 41,
  55. "latin7_general_cs": 42,
  56. "macce_bin": 43,
  57. "cp1250_croatian_ci": 44,
  58. "utf8mb4_general_ci": 45,
  59. "utf8mb4_bin": 46,
  60. "latin1_bin": 47,
  61. "latin1_general_ci": 48,
  62. "latin1_general_cs": 49,
  63. "cp1251_bin": 50,
  64. "cp1251_general_ci": 51,
  65. "cp1251_general_cs": 52,
  66. "macroman_bin": 53,
  67. "utf16_general_ci": 54,
  68. "utf16_bin": 55,
  69. "utf16le_general_ci": 56,
  70. "cp1256_general_ci": 57,
  71. "cp1257_bin": 58,
  72. "cp1257_general_ci": 59,
  73. "utf32_general_ci": 60,
  74. "utf32_bin": 61,
  75. "utf16le_bin": 62,
  76. "binary": 63,
  77. "armscii8_bin": 64,
  78. "ascii_bin": 65,
  79. "cp1250_bin": 66,
  80. "cp1256_bin": 67,
  81. "cp866_bin": 68,
  82. "dec8_bin": 69,
  83. "greek_bin": 70,
  84. "hebrew_bin": 71,
  85. "hp8_bin": 72,
  86. "keybcs2_bin": 73,
  87. "koi8r_bin": 74,
  88. "koi8u_bin": 75,
  89. "latin2_bin": 77,
  90. "latin5_bin": 78,
  91. "latin7_bin": 79,
  92. "cp850_bin": 80,
  93. "cp852_bin": 81,
  94. "swe7_bin": 82,
  95. "utf8_bin": 83,
  96. "big5_bin": 84,
  97. "euckr_bin": 85,
  98. "gb2312_bin": 86,
  99. "gbk_bin": 87,
  100. "sjis_bin": 88,
  101. "tis620_bin": 89,
  102. "ucs2_bin": 90,
  103. "ujis_bin": 91,
  104. "geostd8_general_ci": 92,
  105. "geostd8_bin": 93,
  106. "latin1_spanish_ci": 94,
  107. "cp932_japanese_ci": 95,
  108. "cp932_bin": 96,
  109. "eucjpms_japanese_ci": 97,
  110. "eucjpms_bin": 98,
  111. "cp1250_polish_ci": 99,
  112. "utf16_unicode_ci": 101,
  113. "utf16_icelandic_ci": 102,
  114. "utf16_latvian_ci": 103,
  115. "utf16_romanian_ci": 104,
  116. "utf16_slovenian_ci": 105,
  117. "utf16_polish_ci": 106,
  118. "utf16_estonian_ci": 107,
  119. "utf16_spanish_ci": 108,
  120. "utf16_swedish_ci": 109,
  121. "utf16_turkish_ci": 110,
  122. "utf16_czech_ci": 111,
  123. "utf16_danish_ci": 112,
  124. "utf16_lithuanian_ci": 113,
  125. "utf16_slovak_ci": 114,
  126. "utf16_spanish2_ci": 115,
  127. "utf16_roman_ci": 116,
  128. "utf16_persian_ci": 117,
  129. "utf16_esperanto_ci": 118,
  130. "utf16_hungarian_ci": 119,
  131. "utf16_sinhala_ci": 120,
  132. "utf16_german2_ci": 121,
  133. "utf16_croatian_ci": 122,
  134. "utf16_unicode_520_ci": 123,
  135. "utf16_vietnamese_ci": 124,
  136. "ucs2_unicode_ci": 128,
  137. "ucs2_icelandic_ci": 129,
  138. "ucs2_latvian_ci": 130,
  139. "ucs2_romanian_ci": 131,
  140. "ucs2_slovenian_ci": 132,
  141. "ucs2_polish_ci": 133,
  142. "ucs2_estonian_ci": 134,
  143. "ucs2_spanish_ci": 135,
  144. "ucs2_swedish_ci": 136,
  145. "ucs2_turkish_ci": 137,
  146. "ucs2_czech_ci": 138,
  147. "ucs2_danish_ci": 139,
  148. "ucs2_lithuanian_ci": 140,
  149. "ucs2_slovak_ci": 141,
  150. "ucs2_spanish2_ci": 142,
  151. "ucs2_roman_ci": 143,
  152. "ucs2_persian_ci": 144,
  153. "ucs2_esperanto_ci": 145,
  154. "ucs2_hungarian_ci": 146,
  155. "ucs2_sinhala_ci": 147,
  156. "ucs2_german2_ci": 148,
  157. "ucs2_croatian_ci": 149,
  158. "ucs2_unicode_520_ci": 150,
  159. "ucs2_vietnamese_ci": 151,
  160. "ucs2_general_mysql500_ci": 159,
  161. "utf32_unicode_ci": 160,
  162. "utf32_icelandic_ci": 161,
  163. "utf32_latvian_ci": 162,
  164. "utf32_romanian_ci": 163,
  165. "utf32_slovenian_ci": 164,
  166. "utf32_polish_ci": 165,
  167. "utf32_estonian_ci": 166,
  168. "utf32_spanish_ci": 167,
  169. "utf32_swedish_ci": 168,
  170. "utf32_turkish_ci": 169,
  171. "utf32_czech_ci": 170,
  172. "utf32_danish_ci": 171,
  173. "utf32_lithuanian_ci": 172,
  174. "utf32_slovak_ci": 173,
  175. "utf32_spanish2_ci": 174,
  176. "utf32_roman_ci": 175,
  177. "utf32_persian_ci": 176,
  178. "utf32_esperanto_ci": 177,
  179. "utf32_hungarian_ci": 178,
  180. "utf32_sinhala_ci": 179,
  181. "utf32_german2_ci": 180,
  182. "utf32_croatian_ci": 181,
  183. "utf32_unicode_520_ci": 182,
  184. "utf32_vietnamese_ci": 183,
  185. "utf8_unicode_ci": 192,
  186. "utf8_icelandic_ci": 193,
  187. "utf8_latvian_ci": 194,
  188. "utf8_romanian_ci": 195,
  189. "utf8_slovenian_ci": 196,
  190. "utf8_polish_ci": 197,
  191. "utf8_estonian_ci": 198,
  192. "utf8_spanish_ci": 199,
  193. "utf8_swedish_ci": 200,
  194. "utf8_turkish_ci": 201,
  195. "utf8_czech_ci": 202,
  196. "utf8_danish_ci": 203,
  197. "utf8_lithuanian_ci": 204,
  198. "utf8_slovak_ci": 205,
  199. "utf8_spanish2_ci": 206,
  200. "utf8_roman_ci": 207,
  201. "utf8_persian_ci": 208,
  202. "utf8_esperanto_ci": 209,
  203. "utf8_hungarian_ci": 210,
  204. "utf8_sinhala_ci": 211,
  205. "utf8_german2_ci": 212,
  206. "utf8_croatian_ci": 213,
  207. "utf8_unicode_520_ci": 214,
  208. "utf8_vietnamese_ci": 215,
  209. "utf8_general_mysql500_ci": 223,
  210. "utf8mb4_unicode_ci": 224,
  211. "utf8mb4_icelandic_ci": 225,
  212. "utf8mb4_latvian_ci": 226,
  213. "utf8mb4_romanian_ci": 227,
  214. "utf8mb4_slovenian_ci": 228,
  215. "utf8mb4_polish_ci": 229,
  216. "utf8mb4_estonian_ci": 230,
  217. "utf8mb4_spanish_ci": 231,
  218. "utf8mb4_swedish_ci": 232,
  219. "utf8mb4_turkish_ci": 233,
  220. "utf8mb4_czech_ci": 234,
  221. "utf8mb4_danish_ci": 235,
  222. "utf8mb4_lithuanian_ci": 236,
  223. "utf8mb4_slovak_ci": 237,
  224. "utf8mb4_spanish2_ci": 238,
  225. "utf8mb4_roman_ci": 239,
  226. "utf8mb4_persian_ci": 240,
  227. "utf8mb4_esperanto_ci": 241,
  228. "utf8mb4_hungarian_ci": 242,
  229. "utf8mb4_sinhala_ci": 243,
  230. "utf8mb4_german2_ci": 244,
  231. "utf8mb4_croatian_ci": 245,
  232. "utf8mb4_unicode_520_ci": 246,
  233. "utf8mb4_vietnamese_ci": 247,
  234. }
  235. // A blacklist of collations which is unsafe to interpolate parameters.
  236. // These multibyte encodings may contains 0x5c (`\`) in their trailing bytes.
  237. var unsafeCollations = map[string]bool{
  238. "big5_chinese_ci": true,
  239. "sjis_japanese_ci": true,
  240. "gbk_chinese_ci": true,
  241. "big5_bin": true,
  242. "gb2312_bin": true,
  243. "gbk_bin": true,
  244. "sjis_bin": true,
  245. "cp932_japanese_ci": true,
  246. "cp932_bin": true,
  247. }
上海开阖软件有限公司 沪ICP备12045867号-1