charset_collation_3.result 8.68 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
DROP USER dbdict_test@localhost;
CREATE USER dbdict_test@localhost;
# Establish connection con (user=dbdict_test)

SELECT *
FROM information_schema.character_sets
ORDER BY character_set_name;
CHARACTER_SET_NAME	DEFAULT_COLLATE_NAME	DESCRIPTION	MAXLEN
armscii8	armscii8_general_ci	ARMSCII-8 Armenian	1
ascii	ascii_general_ci	US ASCII	1
big5	big5_chinese_ci	Big5 Traditional Chinese	2
binary	binary	Binary pseudo charset	1
cp1250	cp1250_general_ci	Windows Central European	1
cp1251	cp1251_general_ci	Windows Cyrillic	1
cp1256	cp1256_general_ci	Windows Arabic	1
cp1257	cp1257_general_ci	Windows Baltic	1
cp850	cp850_general_ci	DOS West European	1
cp852	cp852_general_ci	DOS Central European	1
cp866	cp866_general_ci	DOS Russian	1
cp932	cp932_japanese_ci	SJIS for Windows Japanese	2
dec8	dec8_swedish_ci	DEC West European	1
eucjpms	eucjpms_japanese_ci	UJIS for Windows Japanese	3
euckr	euckr_korean_ci	EUC-KR Korean	2
gb2312	gb2312_chinese_ci	GB2312 Simplified Chinese	2
gbk	gbk_chinese_ci	GBK Simplified Chinese	2
geostd8	geostd8_general_ci	GEOSTD8 Georgian	1
greek	greek_general_ci	ISO 8859-7 Greek	1
hebrew	hebrew_general_ci	ISO 8859-8 Hebrew	1
hp8	hp8_english_ci	HP West European	1
keybcs2	keybcs2_general_ci	DOS Kamenicky Czech-Slovak	1
koi8r	koi8r_general_ci	KOI8-R Relcom Russian	1
koi8u	koi8u_general_ci	KOI8-U Ukrainian	1
latin1	latin1_swedish_ci	cp1252 West European	1
latin2	latin2_general_ci	ISO 8859-2 Central European	1
latin5	latin5_turkish_ci	ISO 8859-9 Turkish	1
latin7	latin7_general_ci	ISO 8859-13 Baltic	1
macce	macce_general_ci	Mac Central European	1
macroman	macroman_general_ci	Mac West European	1
sjis	sjis_japanese_ci	Shift-JIS Japanese	2
swe7	swe7_swedish_ci	7bit Swedish	1
tis620	tis620_thai_ci	TIS620 Thai	1
ucs2	ucs2_general_ci	UCS-2 Unicode	2
ujis	ujis_japanese_ci	EUC-JP Japanese	3
utf8	utf8_general_ci	UTF-8 Unicode	3

SELECT *
FROM information_schema.collations
ORDER BY collation_name;
COLLATION_NAME	CHARACTER_SET_NAME	ID	IS_DEFAULT	IS_COMPILED	SORTLEN
50 51 52 53
armscii8_bin	armscii8	64			0
armscii8_general_ci	armscii8	32	Yes		0
ascii_bin	ascii	65			0
ascii_general_ci	ascii	11	Yes		0
54 55 56 57 58 59 60
big5_bin	big5	84		Yes	1
big5_chinese_ci	big5	1	Yes	Yes	1
binary	binary	63	Yes	Yes	1
cp1250_bin	cp1250	66		Yes	1
cp1250_croatian_ci	cp1250	44		Yes	1
cp1250_czech_cs	cp1250	34		Yes	2
cp1250_general_ci	cp1250	26	Yes	Yes	1
61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77
cp1250_polish_ci	cp1250	99		Yes	1
cp1251_bin	cp1251	50			0
cp1251_bulgarian_ci	cp1251	14			0
cp1251_general_ci	cp1251	51	Yes		0
cp1251_general_cs	cp1251	52			0
cp1251_ukrainian_ci	cp1251	23			0
cp1256_bin	cp1256	67			0
cp1256_general_ci	cp1256	57	Yes		0
cp1257_bin	cp1257	58			0
cp1257_general_ci	cp1257	59	Yes		0
cp1257_lithuanian_ci	cp1257	29			0
cp850_bin	cp850	80			0
cp850_general_ci	cp850	4	Yes		0
cp852_bin	cp852	81			0
cp852_general_ci	cp852	40	Yes		0
cp866_bin	cp866	68			0
cp866_general_ci	cp866	36	Yes		0
78 79
cp932_bin	cp932	96		Yes	1
cp932_japanese_ci	cp932	95	Yes	Yes	1
80 81
dec8_bin	dec8	69			0
dec8_swedish_ci	dec8	3	Yes		0
82 83 84 85 86 87 88 89
eucjpms_bin	eucjpms	98		Yes	1
eucjpms_japanese_ci	eucjpms	97	Yes	Yes	1
euckr_bin	euckr	85		Yes	1
euckr_korean_ci	euckr	19	Yes	Yes	1
gb2312_bin	gb2312	86		Yes	1
gb2312_chinese_ci	gb2312	24	Yes	Yes	1
gbk_bin	gbk	87		Yes	1
gbk_chinese_ci	gbk	28	Yes	Yes	1
90 91 92 93 94 95 96 97 98 99 100 101 102 103
geostd8_bin	geostd8	93			0
geostd8_general_ci	geostd8	92	Yes		0
greek_bin	greek	70			0
greek_general_ci	greek	25	Yes		0
hebrew_bin	hebrew	71			0
hebrew_general_ci	hebrew	16	Yes		0
hp8_bin	hp8	72			0
hp8_english_ci	hp8	6	Yes		0
keybcs2_bin	keybcs2	73			0
keybcs2_general_ci	keybcs2	37	Yes		0
koi8r_bin	koi8r	74			0
koi8r_general_ci	koi8r	7	Yes		0
koi8u_bin	koi8u	75			0
koi8u_general_ci	koi8u	22	Yes		0
104 105 106 107 108 109 110 111 112 113 114 115 116
latin1_bin	latin1	47		Yes	1
latin1_danish_ci	latin1	15		Yes	1
latin1_general_ci	latin1	48		Yes	1
latin1_general_cs	latin1	49		Yes	1
latin1_german1_ci	latin1	5		Yes	1
latin1_german2_ci	latin1	31		Yes	2
latin1_spanish_ci	latin1	94		Yes	1
latin1_swedish_ci	latin1	8	Yes	Yes	1
latin2_bin	latin2	77		Yes	1
latin2_croatian_ci	latin2	27		Yes	1
latin2_czech_cs	latin2	2		Yes	4
latin2_general_ci	latin2	9	Yes	Yes	1
latin2_hungarian_ci	latin2	21		Yes	1
117 118 119 120 121 122 123 124 125 126
latin5_bin	latin5	78			0
latin5_turkish_ci	latin5	30	Yes		0
latin7_bin	latin7	79			0
latin7_estonian_cs	latin7	20			0
latin7_general_ci	latin7	41	Yes		0
latin7_general_cs	latin7	42			0
macce_bin	macce	43			0
macce_general_ci	macce	38	Yes		0
macroman_bin	macroman	53			0
macroman_general_ci	macroman	39	Yes		0
127 128
sjis_bin	sjis	88		Yes	1
sjis_japanese_ci	sjis	13	Yes	Yes	1
129 130
swe7_bin	swe7	82			0
swe7_swedish_ci	swe7	10	Yes		0
131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193
tis620_bin	tis620	89		Yes	1
tis620_thai_ci	tis620	18	Yes	Yes	4
ucs2_bin	ucs2	90		Yes	1
ucs2_czech_ci	ucs2	138		Yes	8
ucs2_danish_ci	ucs2	139		Yes	8
ucs2_esperanto_ci	ucs2	145		Yes	8
ucs2_estonian_ci	ucs2	134		Yes	8
ucs2_general_ci	ucs2	35	Yes	Yes	1
ucs2_hungarian_ci	ucs2	146		Yes	8
ucs2_icelandic_ci	ucs2	129		Yes	8
ucs2_latvian_ci	ucs2	130		Yes	8
ucs2_lithuanian_ci	ucs2	140		Yes	8
ucs2_persian_ci	ucs2	144		Yes	8
ucs2_polish_ci	ucs2	133		Yes	8
ucs2_romanian_ci	ucs2	131		Yes	8
ucs2_roman_ci	ucs2	143		Yes	8
ucs2_slovak_ci	ucs2	141		Yes	8
ucs2_slovenian_ci	ucs2	132		Yes	8
ucs2_spanish2_ci	ucs2	142		Yes	8
ucs2_spanish_ci	ucs2	135		Yes	8
ucs2_swedish_ci	ucs2	136		Yes	8
ucs2_turkish_ci	ucs2	137		Yes	8
ucs2_unicode_ci	ucs2	128		Yes	8
ujis_bin	ujis	91		Yes	1
ujis_japanese_ci	ujis	12	Yes	Yes	1
utf8_bin	utf8	83		Yes	1
utf8_czech_ci	utf8	202		Yes	8
utf8_danish_ci	utf8	203		Yes	8
utf8_esperanto_ci	utf8	209		Yes	8
utf8_estonian_ci	utf8	198		Yes	8
utf8_general_ci	utf8	33	Yes	Yes	1
utf8_hungarian_ci	utf8	210		Yes	8
utf8_icelandic_ci	utf8	193		Yes	8
utf8_latvian_ci	utf8	194		Yes	8
utf8_lithuanian_ci	utf8	204		Yes	8
utf8_persian_ci	utf8	208		Yes	8
utf8_polish_ci	utf8	197		Yes	8
utf8_romanian_ci	utf8	195		Yes	8
utf8_roman_ci	utf8	207		Yes	8
utf8_slovak_ci	utf8	205		Yes	8
utf8_slovenian_ci	utf8	196		Yes	8
utf8_spanish2_ci	utf8	206		Yes	8
utf8_spanish_ci	utf8	199		Yes	8
utf8_swedish_ci	utf8	200		Yes	8
utf8_turkish_ci	utf8	201		Yes	8
utf8_unicode_ci	utf8	192		Yes	8


SELECT *
FROM information_schema.collation_character_set_applicability
ORDER BY collation_name, character_set_name;
COLLATION_NAME	CHARACTER_SET_NAME
armscii8_bin	armscii8
armscii8_general_ci	armscii8
ascii_bin	ascii
ascii_general_ci	ascii
big5_bin	big5
big5_chinese_ci	big5
binary	binary
cp1250_bin	cp1250
cp1250_croatian_ci	cp1250
cp1250_czech_cs	cp1250
cp1250_general_ci	cp1250
194
cp1250_polish_ci	cp1250
195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218
cp1251_bin	cp1251
cp1251_bulgarian_ci	cp1251
cp1251_general_ci	cp1251
cp1251_general_cs	cp1251
cp1251_ukrainian_ci	cp1251
cp1256_bin	cp1256
cp1256_general_ci	cp1256
cp1257_bin	cp1257
cp1257_general_ci	cp1257
cp1257_lithuanian_ci	cp1257
cp850_bin	cp850
cp850_general_ci	cp850
cp852_bin	cp852
cp852_general_ci	cp852
cp866_bin	cp866
cp866_general_ci	cp866
cp932_bin	cp932
cp932_japanese_ci	cp932
dec8_bin	dec8
dec8_swedish_ci	dec8
eucjpms_bin	eucjpms
eucjpms_japanese_ci	eucjpms
euckr_bin	euckr
euckr_korean_ci	euckr
219
filename	filename
220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312
gb2312_bin	gb2312
gb2312_chinese_ci	gb2312
gbk_bin	gbk
gbk_chinese_ci	gbk
geostd8_bin	geostd8
geostd8_general_ci	geostd8
greek_bin	greek
greek_general_ci	greek
hebrew_bin	hebrew
hebrew_general_ci	hebrew
hp8_bin	hp8
hp8_english_ci	hp8
keybcs2_bin	keybcs2
keybcs2_general_ci	keybcs2
koi8r_bin	koi8r
koi8r_general_ci	koi8r
koi8u_bin	koi8u
koi8u_general_ci	koi8u
latin1_bin	latin1
latin1_danish_ci	latin1
latin1_general_ci	latin1
latin1_general_cs	latin1
latin1_german1_ci	latin1
latin1_german2_ci	latin1
latin1_spanish_ci	latin1
latin1_swedish_ci	latin1
latin2_bin	latin2
latin2_croatian_ci	latin2
latin2_czech_cs	latin2
latin2_general_ci	latin2
latin2_hungarian_ci	latin2
latin5_bin	latin5
latin5_turkish_ci	latin5
latin7_bin	latin7
latin7_estonian_cs	latin7
latin7_general_ci	latin7
latin7_general_cs	latin7
macce_bin	macce
macce_general_ci	macce
macroman_bin	macroman
macroman_general_ci	macroman
sjis_bin	sjis
sjis_japanese_ci	sjis
swe7_bin	swe7
swe7_swedish_ci	swe7
tis620_bin	tis620
tis620_thai_ci	tis620
ucs2_bin	ucs2
ucs2_czech_ci	ucs2
ucs2_danish_ci	ucs2
ucs2_esperanto_ci	ucs2
ucs2_estonian_ci	ucs2
ucs2_general_ci	ucs2
ucs2_hungarian_ci	ucs2
ucs2_icelandic_ci	ucs2
ucs2_latvian_ci	ucs2
ucs2_lithuanian_ci	ucs2
ucs2_persian_ci	ucs2
ucs2_polish_ci	ucs2
ucs2_romanian_ci	ucs2
ucs2_roman_ci	ucs2
ucs2_slovak_ci	ucs2
ucs2_slovenian_ci	ucs2
ucs2_spanish2_ci	ucs2
ucs2_spanish_ci	ucs2
ucs2_swedish_ci	ucs2
ucs2_turkish_ci	ucs2
ucs2_unicode_ci	ucs2
ujis_bin	ujis
ujis_japanese_ci	ujis
utf8_bin	utf8
utf8_czech_ci	utf8
utf8_danish_ci	utf8
utf8_esperanto_ci	utf8
utf8_estonian_ci	utf8
utf8_general_ci	utf8
utf8_hungarian_ci	utf8
utf8_icelandic_ci	utf8
utf8_latvian_ci	utf8
utf8_lithuanian_ci	utf8
utf8_persian_ci	utf8
utf8_polish_ci	utf8
utf8_romanian_ci	utf8
utf8_roman_ci	utf8
utf8_slovak_ci	utf8
utf8_slovenian_ci	utf8
utf8_spanish2_ci	utf8
utf8_spanish_ci	utf8
utf8_swedish_ci	utf8
utf8_turkish_ci	utf8
utf8_unicode_ci	utf8
# Switch to connection default + disconnect con
DROP USER dbdict_test@localhost;