Detalhes da Tabela

COLLATIONS | Database: information_schema | Conexão: Teste migração

Estrutura da Tabela

Field Type Null Key Default Extra
COLLATION_NAME varchar(32) NO
CHARACTER_SET_NAME varchar(32) NO
ID bigint(11) NO 0
IS_DEFAULT varchar(3) NO
IS_COMPILED varchar(3) NO
SORTLEN bigint(3) NO 0

Dados da Tabela (máx. 100 linhas)

COLLATION_NAME CHARACTER_SET_NAME ID IS_DEFAULT IS_COMPILED SORTLEN
big5_chinese_ci big5 1 Yes Yes 1
big5_bin big5 84 Yes 1
dec8_swedish_ci dec8 3 Yes Yes 1
dec8_bin dec8 69 Yes 1
cp850_general_ci cp850 4 Yes Yes 1
cp850_bin cp850 80 Yes 1
hp8_english_ci hp8 6 Yes Yes 1
hp8_bin hp8 72 Yes 1
koi8r_general_ci koi8r 7 Yes Yes 1
koi8r_bin koi8r 74 Yes 1
latin1_german1_ci latin1 5 Yes 1
latin1_swedish_ci latin1 8 Yes Yes 1
latin1_danish_ci latin1 15 Yes 1
latin1_german2_ci latin1 31 Yes 2
latin1_bin latin1 47 Yes 1
latin1_general_ci latin1 48 Yes 1
latin1_general_cs latin1 49 Yes 1
latin1_spanish_ci latin1 94 Yes 1
latin2_czech_cs latin2 2 Yes 4
latin2_general_ci latin2 9 Yes Yes 1
latin2_hungarian_ci latin2 21 Yes 1
latin2_croatian_ci latin2 27 Yes 1
latin2_bin latin2 77 Yes 1
swe7_swedish_ci swe7 10 Yes Yes 1
swe7_bin swe7 82 Yes 1
ascii_general_ci ascii 11 Yes Yes 1
ascii_bin ascii 65 Yes 1
ujis_japanese_ci ujis 12 Yes Yes 1
ujis_bin ujis 91 Yes 1
sjis_japanese_ci sjis 13 Yes Yes 1
sjis_bin sjis 88 Yes 1
hebrew_general_ci hebrew 16 Yes Yes 1
hebrew_bin hebrew 71 Yes 1
tis620_thai_ci tis620 18 Yes Yes 4
tis620_bin tis620 89 Yes 1
euckr_korean_ci euckr 19 Yes Yes 1
euckr_bin euckr 85 Yes 1
koi8u_general_ci koi8u 22 Yes Yes 1
koi8u_bin koi8u 75 Yes 1
gb2312_chinese_ci gb2312 24 Yes Yes 1
gb2312_bin gb2312 86 Yes 1
greek_general_ci greek 25 Yes Yes 1
greek_bin greek 70 Yes 1
cp1250_general_ci cp1250 26 Yes Yes 1
cp1250_czech_cs cp1250 34 Yes 2
cp1250_croatian_ci cp1250 44 Yes 1
cp1250_bin cp1250 66 Yes 1
cp1250_polish_ci cp1250 99 Yes 1
gbk_chinese_ci gbk 28 Yes Yes 1
gbk_bin gbk 87 Yes 1
latin5_turkish_ci latin5 30 Yes Yes 1
latin5_bin latin5 78 Yes 1
armscii8_general_ci armscii8 32 Yes Yes 1
armscii8_bin armscii8 64 Yes 1
utf8_general_ci utf8 33 Yes Yes 1
utf8_bin utf8 83 Yes 1
utf8_unicode_ci utf8 192 Yes 8
utf8_icelandic_ci utf8 193 Yes 8
utf8_latvian_ci utf8 194 Yes 8
utf8_romanian_ci utf8 195 Yes 8
utf8_slovenian_ci utf8 196 Yes 8
utf8_polish_ci utf8 197 Yes 8
utf8_estonian_ci utf8 198 Yes 8
utf8_spanish_ci utf8 199 Yes 8
utf8_swedish_ci utf8 200 Yes 8
utf8_turkish_ci utf8 201 Yes 8
utf8_czech_ci utf8 202 Yes 8
utf8_danish_ci utf8 203 Yes 8
utf8_lithuanian_ci utf8 204 Yes 8
utf8_slovak_ci utf8 205 Yes 8
utf8_spanish2_ci utf8 206 Yes 8
utf8_roman_ci utf8 207 Yes 8
utf8_persian_ci utf8 208 Yes 8
utf8_esperanto_ci utf8 209 Yes 8
utf8_hungarian_ci utf8 210 Yes 8
utf8_sinhala_ci utf8 211 Yes 8
utf8_german2_ci utf8 212 Yes 8
utf8_croatian_ci utf8 213 Yes 8
utf8_unicode_520_ci utf8 214 Yes 8
utf8_vietnamese_ci utf8 215 Yes 8
utf8_general_mysql500_ci utf8 223 Yes 1
ucs2_general_ci ucs2 35 Yes Yes 1
ucs2_bin ucs2 90 Yes 1
ucs2_unicode_ci ucs2 128 Yes 8
ucs2_icelandic_ci ucs2 129 Yes 8
ucs2_latvian_ci ucs2 130 Yes 8
ucs2_romanian_ci ucs2 131 Yes 8
ucs2_slovenian_ci ucs2 132 Yes 8
ucs2_polish_ci ucs2 133 Yes 8
ucs2_estonian_ci ucs2 134 Yes 8
ucs2_spanish_ci ucs2 135 Yes 8
ucs2_swedish_ci ucs2 136 Yes 8
ucs2_turkish_ci ucs2 137 Yes 8
ucs2_czech_ci ucs2 138 Yes 8
ucs2_danish_ci ucs2 139 Yes 8
ucs2_lithuanian_ci ucs2 140 Yes 8
ucs2_slovak_ci ucs2 141 Yes 8
ucs2_spanish2_ci ucs2 142 Yes 8
ucs2_roman_ci ucs2 143 Yes 8
ucs2_persian_ci ucs2 144 Yes 8
Voltar para Tabelas Voltar para Bases