~drizzle-trunk/drizzle/development

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
utf16	utf16_general_ci	UTF-16 Unicode	4
utf32	utf32_general_ci	UTF-32 Unicode	4
utf8	utf8_general_ci	UTF-8 Unicode	4
utf8mb3	utf8mb3_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
armscii8_bin	armscii8	64			0
armscii8_general_ci	armscii8	32	Yes		0
ascii_bin	ascii	65			0
ascii_general_ci	ascii	11	Yes		0
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
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
cp932_bin	cp932	96		Yes	1
cp932_japanese_ci	cp932	95	Yes	Yes	1
dec8_bin	dec8	69			0
dec8_swedish_ci	dec8	3	Yes		0
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
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
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
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
sjis_bin	sjis	88		Yes	1
sjis_japanese_ci	sjis	13	Yes	Yes	1
swe7_bin	swe7	82			0
swe7_swedish_ci	swe7	10	Yes		0
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_sinhala_ci	ucs2	147		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
utf16_bin	utf16	55		Yes	1
utf16_czech_ci	utf16	111		Yes	8
utf16_danish_ci	utf16	112		Yes	8
utf16_esperanto_ci	utf16	118		Yes	8
utf16_estonian_ci	utf16	107		Yes	8
utf16_general_ci	utf16	54	Yes	Yes	1
utf16_hungarian_ci	utf16	119		Yes	8
utf16_icelandic_ci	utf16	102		Yes	8
utf16_latvian_ci	utf16	103		Yes	8
utf16_lithuanian_ci	utf16	113		Yes	8
utf16_persian_ci	utf16	117		Yes	8
utf16_polish_ci	utf16	106		Yes	8
utf16_romanian_ci	utf16	104		Yes	8
utf16_roman_ci	utf16	116		Yes	8
utf16_sinhala_ci	utf16	120		Yes	8
utf16_slovak_ci	utf16	114		Yes	8
utf16_slovenian_ci	utf16	105		Yes	8
utf16_spanish2_ci	utf16	115		Yes	8
utf16_spanish_ci	utf16	108		Yes	8
utf16_swedish_ci	utf16	109		Yes	8
utf16_turkish_ci	utf16	110		Yes	8
utf16_unicode_ci	utf16	101		Yes	8
utf32_bin	utf32	61		Yes	1
utf32_czech_ci	utf32	170		Yes	8
utf32_danish_ci	utf32	171		Yes	8
utf32_esperanto_ci	utf32	177		Yes	8
utf32_estonian_ci	utf32	166		Yes	8
utf32_general_ci	utf32	60	Yes	Yes	1
utf32_hungarian_ci	utf32	178		Yes	8
utf32_icelandic_ci	utf32	161		Yes	8
utf32_latvian_ci	utf32	162		Yes	8
utf32_lithuanian_ci	utf32	172		Yes	8
utf32_persian_ci	utf32	176		Yes	8
utf32_polish_ci	utf32	165		Yes	8
utf32_romanian_ci	utf32	163		Yes	8
utf32_roman_ci	utf32	175		Yes	8
utf32_sinhala_ci	utf32	179		Yes	8
utf32_slovak_ci	utf32	173		Yes	8
utf32_slovenian_ci	utf32	164		Yes	8
utf32_spanish2_ci	utf32	174		Yes	8
utf32_spanish_ci	utf32	167		Yes	8
utf32_swedish_ci	utf32	168		Yes	8
utf32_turkish_ci	utf32	169		Yes	8
utf32_unicode_ci	utf32	160		Yes	8
utf8mb3_bin	utf8mb3	83		Yes	1
utf8mb3_czech_ci	utf8mb3	202		Yes	8
utf8mb3_danish_ci	utf8mb3	203		Yes	8
utf8mb3_esperanto_ci	utf8mb3	209		Yes	8
utf8mb3_estonian_ci	utf8mb3	198		Yes	8
utf8mb3_general_ci	utf8mb3	33	Yes	Yes	1
utf8mb3_hungarian_ci	utf8mb3	210		Yes	8
utf8mb3_icelandic_ci	utf8mb3	193		Yes	8
utf8mb3_latvian_ci	utf8mb3	194		Yes	8
utf8mb3_lithuanian_ci	utf8mb3	204		Yes	8
utf8mb3_persian_ci	utf8mb3	208		Yes	8
utf8mb3_polish_ci	utf8mb3	197		Yes	8
utf8mb3_romanian_ci	utf8mb3	195		Yes	8
utf8mb3_roman_ci	utf8mb3	207		Yes	8
utf8mb3_sinhala_ci	utf8mb3	211		Yes	8
utf8mb3_slovak_ci	utf8mb3	205		Yes	8
utf8mb3_slovenian_ci	utf8mb3	196		Yes	8
utf8mb3_spanish2_ci	utf8mb3	206		Yes	8
utf8mb3_spanish_ci	utf8mb3	199		Yes	8
utf8mb3_swedish_ci	utf8mb3	200		Yes	8
utf8mb3_turkish_ci	utf8mb3	201		Yes	8
utf8mb3_unicode_ci	utf8mb3	192		Yes	8
utf8_bin	utf8	46		Yes	1
utf8_czech_ci	utf8	234		Yes	8
utf8_danish_ci	utf8	235		Yes	8
utf8_esperanto_ci	utf8	241		Yes	8
utf8_estonian_ci	utf8	230		Yes	8
utf8_general_ci	utf8	45	Yes	Yes	1
utf8_hungarian_ci	utf8	242		Yes	8
utf8_icelandic_ci	utf8	225		Yes	8
utf8_latvian_ci	utf8	226		Yes	8
utf8_lithuanian_ci	utf8	236		Yes	8
utf8_persian_ci	utf8	240		Yes	8
utf8_polish_ci	utf8	229		Yes	8
utf8_romanian_ci	utf8	227		Yes	8
utf8_roman_ci	utf8	239		Yes	8
utf8_sinhala_ci	utf8	243		Yes	8
utf8_slovak_ci	utf8	237		Yes	8
utf8_slovenian_ci	utf8	228		Yes	8
utf8_spanish2_ci	utf8	238		Yes	8
utf8_spanish_ci	utf8	231		Yes	8
utf8_swedish_ci	utf8	232		Yes	8
utf8_turkish_ci	utf8	233		Yes	8
utf8_unicode_ci	utf8	224		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
cp1250_polish_ci	cp1250
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
filename	filename
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_sinhala_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
utf16_bin	utf16
utf16_czech_ci	utf16
utf16_danish_ci	utf16
utf16_esperanto_ci	utf16
utf16_estonian_ci	utf16
utf16_general_ci	utf16
utf16_hungarian_ci	utf16
utf16_icelandic_ci	utf16
utf16_latvian_ci	utf16
utf16_lithuanian_ci	utf16
utf16_persian_ci	utf16
utf16_polish_ci	utf16
utf16_romanian_ci	utf16
utf16_roman_ci	utf16
utf16_sinhala_ci	utf16
utf16_slovak_ci	utf16
utf16_slovenian_ci	utf16
utf16_spanish2_ci	utf16
utf16_spanish_ci	utf16
utf16_swedish_ci	utf16
utf16_turkish_ci	utf16
utf16_unicode_ci	utf16
utf32_bin	utf32
utf32_czech_ci	utf32
utf32_danish_ci	utf32
utf32_esperanto_ci	utf32
utf32_estonian_ci	utf32
utf32_general_ci	utf32
utf32_hungarian_ci	utf32
utf32_icelandic_ci	utf32
utf32_latvian_ci	utf32
utf32_lithuanian_ci	utf32
utf32_persian_ci	utf32
utf32_polish_ci	utf32
utf32_romanian_ci	utf32
utf32_roman_ci	utf32
utf32_sinhala_ci	utf32
utf32_slovak_ci	utf32
utf32_slovenian_ci	utf32
utf32_spanish2_ci	utf32
utf32_spanish_ci	utf32
utf32_swedish_ci	utf32
utf32_turkish_ci	utf32
utf32_unicode_ci	utf32
utf8mb3_bin	utf8mb3
utf8mb3_czech_ci	utf8mb3
utf8mb3_danish_ci	utf8mb3
utf8mb3_esperanto_ci	utf8mb3
utf8mb3_estonian_ci	utf8mb3
utf8mb3_general_ci	utf8mb3
utf8mb3_hungarian_ci	utf8mb3
utf8mb3_icelandic_ci	utf8mb3
utf8mb3_latvian_ci	utf8mb3
utf8mb3_lithuanian_ci	utf8mb3
utf8mb3_persian_ci	utf8mb3
utf8mb3_polish_ci	utf8mb3
utf8mb3_romanian_ci	utf8mb3
utf8mb3_roman_ci	utf8mb3
utf8mb3_sinhala_ci	utf8mb3
utf8mb3_slovak_ci	utf8mb3
utf8mb3_slovenian_ci	utf8mb3
utf8mb3_spanish2_ci	utf8mb3
utf8mb3_spanish_ci	utf8mb3
utf8mb3_swedish_ci	utf8mb3
utf8mb3_turkish_ci	utf8mb3
utf8mb3_unicode_ci	utf8mb3
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_sinhala_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;