SQL-Browser

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

   show less  show more             Upload SQL file   Search   MySQl Documentation
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 197    <<    <    >    >>

View: compact   The Query contains 6 Columns
 # COLLATION_NAME CHARACTER_SET_NAME ID IS_DEFAULT IS_COMPILED SORTLEN
  edit delete1. 
big5_chinese_ci
big5
1
Yes
Yes
1
  edit delete2. 
big5_bin
big5
84
Yes
1
  edit delete3. 
dec8_swedish_ci
dec8
3
Yes
Yes
1
  edit delete4. 
dec8_bin
dec8
69
Yes
1
  edit delete5. 
cp850_general_ci
cp850
4
Yes
Yes
1
  edit delete6. 
cp850_bin
cp850
80
Yes
1
  edit delete7. 
hp8_english_ci
hp8
6
Yes
Yes
1
  edit delete8. 
hp8_bin
hp8
72
Yes
1
  edit delete9. 
koi8r_general_ci
koi8r
7
Yes
Yes
1
  edit delete10. 
koi8r_bin
koi8r
74
Yes
1
  edit delete11. 
latin1_german1_ci
latin1
5
Yes
1
  edit delete12. 
latin1_swedish_ci
latin1
8
Yes
Yes
1
  edit delete13. 
latin1_danish_ci
latin1
15
Yes
1
  edit delete14. 
latin1_german2_ci
latin1
31
Yes
2
  edit delete15. 
latin1_bin
latin1
47
Yes
1
  edit delete16. 
latin1_general_ci
latin1
48
Yes
1
  edit delete17. 
latin1_general_cs
latin1
49
Yes
1
  edit delete18. 
latin1_spanish_ci
latin1
94
Yes
1
  edit delete19. 
latin2_czech_cs
latin2
2
Yes
4
  edit delete20. 
latin2_general_ci
latin2
9
Yes
Yes
1
  edit delete21. 
latin2_hungarian_ci
latin2
21
Yes
1
  edit delete22. 
latin2_croatian_ci
latin2
27
Yes
1
  edit delete23. 
latin2_bin
latin2
77
Yes
1
  edit delete24. 
swe7_swedish_ci
swe7
10
Yes
Yes
1
  edit delete25. 
swe7_bin
swe7
82
Yes
1
  edit delete26. 
ascii_general_ci
ascii
11
Yes
Yes
1
  edit delete27. 
ascii_bin
ascii
65
Yes
1
  edit delete28. 
ujis_japanese_ci
ujis
12
Yes
Yes
1
  edit delete29. 
ujis_bin
ujis
91
Yes
1
  edit delete30. 
sjis_japanese_ci
sjis
13
Yes
Yes
1

records 1 - 30 from totally 197    <<    <    >    >>