[Tools]  Database: `information_schema`  Table: `COLLATIONS`

         ---               

SELECT * FROM `COLLATIONS`

The execution of SQL Statements can manipulate data. TAKE CARE! The Authors don't accept any liability for damaged or lost data.

Data View

new record    Edit table structure

Table `information_schema`.`COLLATIONS`
records 1 - 30 from totally 219    <<    <    >    >>

View: compact   The Query contains 6 Columns
	#	COLLATION_NAME	CHARACTER_SET_NAME	ID	IS_DEFAULT	IS_COMPILED	SORTLEN
	1.	big5_chinese_ci	big5	1	Yes	Yes	1
	2.	big5_bin	big5	84		Yes	1
	3.	dec8_swedish_ci	dec8	3	Yes	Yes	1
	4.	dec8_bin	dec8	69		Yes	1
	5.	cp850_general_ci	cp850	4	Yes	Yes	1
	6.	cp850_bin	cp850	80		Yes	1
	7.	hp8_english_ci	hp8	6	Yes	Yes	1
	8.	hp8_bin	hp8	72		Yes	1
	9.	koi8r_general_ci	koi8r	7	Yes	Yes	1
	10.	koi8r_bin	koi8r	74		Yes	1
	11.	latin1_german1_ci	latin1	5		Yes	1
	12.	latin1_swedish_ci	latin1	8	Yes	Yes	1
	13.	latin1_danish_ci	latin1	15		Yes	1
	14.	latin1_german2_ci	latin1	31		Yes	2
	15.	latin1_bin	latin1	47		Yes	1
	16.	latin1_general_ci	latin1	48		Yes	1
	17.	latin1_general_cs	latin1	49		Yes	1
	18.	latin1_spanish_ci	latin1	94		Yes	1
	19.	latin2_czech_cs	latin2	2		Yes	4
	20.	latin2_general_ci	latin2	9	Yes	Yes	1
	21.	latin2_hungarian_ci	latin2	21		Yes	1
	22.	latin2_croatian_ci	latin2	27		Yes	1
	23.	latin2_bin	latin2	77		Yes	1
	24.	swe7_swedish_ci	swe7	10	Yes	Yes	1
	25.	swe7_bin	swe7	82		Yes	1
	26.	ascii_general_ci	ascii	11	Yes	Yes	1
	27.	ascii_bin	ascii	65		Yes	1
	28.	ujis_japanese_ci	ujis	12	Yes	Yes	1
	29.	ujis_bin	ujis	91		Yes	1
	30.	sjis_japanese_ci	sjis	13	Yes	Yes	1