Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Complete SerializationUtility.GetBytesPerCharacter #337

Closed
bgrainger opened this issue Sep 23, 2017 · 0 comments
Closed

Complete SerializationUtility.GetBytesPerCharacter #337

bgrainger opened this issue Sep 23, 2017 · 0 comments
Assignees

Comments

@bgrainger
Copy link
Member

@bgrainger bgrainger commented Sep 23, 2017

From the query select coll.ID, coll.COLLATION_NAME, cs.MAXLEN from information_schema.collations coll inner join information_schema.character_sets cs using(CHARACTER_SET_NAME) order by coll.ID; on MySQL 8.0.3.

ID Collation Max Length
1 big5_chinese_ci 2
2 latin2_czech_cs 1
3 dec8_swedish_ci 1
4 cp850_general_ci 1
5 latin1_german1_ci 1
6 hp8_english_ci 1
7 koi8r_general_ci 1
8 latin1_swedish_ci 1
9 latin2_general_ci 1
10 swe7_swedish_ci 1
11 ascii_general_ci 1
12 ujis_japanese_ci 3
13 sjis_japanese_ci 2
14 cp1251_bulgarian_ci 1
15 latin1_danish_ci 1
16 hebrew_general_ci 1
18 tis620_thai_ci 1
19 euckr_korean_ci 2
20 latin7_estonian_cs 1
21 latin2_hungarian_ci 1
22 koi8u_general_ci 1
23 cp1251_ukrainian_ci 1
24 gb2312_chinese_ci 2
25 greek_general_ci 1
26 cp1250_general_ci 1
27 latin2_croatian_ci 1
28 gbk_chinese_ci 2
29 cp1257_lithuanian_ci 1
30 latin5_turkish_ci 1
31 latin1_german2_ci 1
32 armscii8_general_ci 1
33 utf8_general_ci 3
34 cp1250_czech_cs 1
35 ucs2_general_ci 2
36 cp866_general_ci 1
37 keybcs2_general_ci 1
38 macce_general_ci 1
39 macroman_general_ci 1
40 cp852_general_ci 1
41 latin7_general_ci 1
42 latin7_general_cs 1
43 macce_bin 1
44 cp1250_croatian_ci 1
45 utf8mb4_general_ci 4
46 utf8mb4_bin 4
47 latin1_bin 1
48 latin1_general_ci 1
49 latin1_general_cs 1
50 cp1251_bin 1
51 cp1251_general_ci 1
52 cp1251_general_cs 1
53 macroman_bin 1
54 utf16_general_ci 4
55 utf16_bin 4
56 utf16le_general_ci 4
57 cp1256_general_ci 1
58 cp1257_bin 1
59 cp1257_general_ci 1
60 utf32_general_ci 4
61 utf32_bin 4
62 utf16le_bin 4
63 binary 1
64 armscii8_bin 1
65 ascii_bin 1
66 cp1250_bin 1
67 cp1256_bin 1
68 cp866_bin 1
69 dec8_bin 1
70 greek_bin 1
71 hebrew_bin 1
72 hp8_bin 1
73 keybcs2_bin 1
74 koi8r_bin 1
75 koi8u_bin 1
76 utf8_tolower_ci 3
77 latin2_bin 1
78 latin5_bin 1
79 latin7_bin 1
80 cp850_bin 1
81 cp852_bin 1
82 swe7_bin 1
83 utf8_bin 3
84 big5_bin 2
85 euckr_bin 2
86 gb2312_bin 2
87 gbk_bin 2
88 sjis_bin 2
89 tis620_bin 1
90 ucs2_bin 2
91 ujis_bin 3
92 geostd8_general_ci 1
93 geostd8_bin 1
94 latin1_spanish_ci 1
95 cp932_japanese_ci 2
96 cp932_bin 2
97 eucjpms_japanese_ci 3
98 eucjpms_bin 3
99 cp1250_polish_ci 1
101 utf16_unicode_ci 4
102 utf16_icelandic_ci 4
103 utf16_latvian_ci 4
104 utf16_romanian_ci 4
105 utf16_slovenian_ci 4
106 utf16_polish_ci 4
107 utf16_estonian_ci 4
108 utf16_spanish_ci 4
109 utf16_swedish_ci 4
110 utf16_turkish_ci 4
111 utf16_czech_ci 4
112 utf16_danish_ci 4
113 utf16_lithuanian_ci 4
114 utf16_slovak_ci 4
115 utf16_spanish2_ci 4
116 utf16_roman_ci 4
117 utf16_persian_ci 4
118 utf16_esperanto_ci 4
119 utf16_hungarian_ci 4
120 utf16_sinhala_ci 4
121 utf16_german2_ci 4
122 utf16_croatian_ci 4
123 utf16_unicode_520_ci 4
124 utf16_vietnamese_ci 4
128 ucs2_unicode_ci 2
129 ucs2_icelandic_ci 2
130 ucs2_latvian_ci 2
131 ucs2_romanian_ci 2
132 ucs2_slovenian_ci 2
133 ucs2_polish_ci 2
134 ucs2_estonian_ci 2
135 ucs2_spanish_ci 2
136 ucs2_swedish_ci 2
137 ucs2_turkish_ci 2
138 ucs2_czech_ci 2
139 ucs2_danish_ci 2
140 ucs2_lithuanian_ci 2
141 ucs2_slovak_ci 2
142 ucs2_spanish2_ci 2
143 ucs2_roman_ci 2
144 ucs2_persian_ci 2
145 ucs2_esperanto_ci 2
146 ucs2_hungarian_ci 2
147 ucs2_sinhala_ci 2
148 ucs2_german2_ci 2
149 ucs2_croatian_ci 2
150 ucs2_unicode_520_ci 2
151 ucs2_vietnamese_ci 2
159 ucs2_general_mysql500_ci 2
160 utf32_unicode_ci 4
161 utf32_icelandic_ci 4
162 utf32_latvian_ci 4
163 utf32_romanian_ci 4
164 utf32_slovenian_ci 4
165 utf32_polish_ci 4
166 utf32_estonian_ci 4
167 utf32_spanish_ci 4
168 utf32_swedish_ci 4
169 utf32_turkish_ci 4
170 utf32_czech_ci 4
171 utf32_danish_ci 4
172 utf32_lithuanian_ci 4
173 utf32_slovak_ci 4
174 utf32_spanish2_ci 4
175 utf32_roman_ci 4
176 utf32_persian_ci 4
177 utf32_esperanto_ci 4
178 utf32_hungarian_ci 4
179 utf32_sinhala_ci 4
180 utf32_german2_ci 4
181 utf32_croatian_ci 4
182 utf32_unicode_520_ci 4
183 utf32_vietnamese_ci 4
192 utf8_unicode_ci 3
193 utf8_icelandic_ci 3
194 utf8_latvian_ci 3
195 utf8_romanian_ci 3
196 utf8_slovenian_ci 3
197 utf8_polish_ci 3
198 utf8_estonian_ci 3
199 utf8_spanish_ci 3
200 utf8_swedish_ci 3
201 utf8_turkish_ci 3
202 utf8_czech_ci 3
203 utf8_danish_ci 3
204 utf8_lithuanian_ci 3
205 utf8_slovak_ci 3
206 utf8_spanish2_ci 3
207 utf8_roman_ci 3
208 utf8_persian_ci 3
209 utf8_esperanto_ci 3
210 utf8_hungarian_ci 3
211 utf8_sinhala_ci 3
212 utf8_german2_ci 3
213 utf8_croatian_ci 3
214 utf8_unicode_520_ci 3
215 utf8_vietnamese_ci 3
223 utf8_general_mysql500_ci 3
224 utf8mb4_unicode_ci 4
225 utf8mb4_icelandic_ci 4
226 utf8mb4_latvian_ci 4
227 utf8mb4_romanian_ci 4
228 utf8mb4_slovenian_ci 4
229 utf8mb4_polish_ci 4
230 utf8mb4_estonian_ci 4
231 utf8mb4_spanish_ci 4
232 utf8mb4_swedish_ci 4
233 utf8mb4_turkish_ci 4
234 utf8mb4_czech_ci 4
235 utf8mb4_danish_ci 4
236 utf8mb4_lithuanian_ci 4
237 utf8mb4_slovak_ci 4
238 utf8mb4_spanish2_ci 4
239 utf8mb4_roman_ci 4
240 utf8mb4_persian_ci 4
241 utf8mb4_esperanto_ci 4
242 utf8mb4_hungarian_ci 4
243 utf8mb4_sinhala_ci 4
244 utf8mb4_german2_ci 4
245 utf8mb4_croatian_ci 4
246 utf8mb4_unicode_520_ci 4
247 utf8mb4_vietnamese_ci 4
248 gb18030_chinese_ci 4
249 gb18030_bin 4
250 gb18030_unicode_520_ci 4
255 utf8mb4_0900_ai_ci 4
256 utf8mb4_de_pb_0900_ai_ci 4
257 utf8mb4_is_0900_ai_ci 4
258 utf8mb4_lv_0900_ai_ci 4
259 utf8mb4_ro_0900_ai_ci 4
260 utf8mb4_sl_0900_ai_ci 4
261 utf8mb4_pl_0900_ai_ci 4
262 utf8mb4_et_0900_ai_ci 4
263 utf8mb4_es_0900_ai_ci 4
264 utf8mb4_sv_0900_ai_ci 4
265 utf8mb4_tr_0900_ai_ci 4
266 utf8mb4_cs_0900_ai_ci 4
267 utf8mb4_da_0900_ai_ci 4
268 utf8mb4_lt_0900_ai_ci 4
269 utf8mb4_sk_0900_ai_ci 4
270 utf8mb4_es_trad_0900_ai_ci 4
271 utf8mb4_la_0900_ai_ci 4
273 utf8mb4_eo_0900_ai_ci 4
274 utf8mb4_hu_0900_ai_ci 4
275 utf8mb4_hr_0900_ai_ci 4
277 utf8mb4_vi_0900_ai_ci 4
278 utf8mb4_0900_as_cs 4
279 utf8mb4_de_pb_0900_as_cs 4
280 utf8mb4_is_0900_as_cs 4
281 utf8mb4_lv_0900_as_cs 4
282 utf8mb4_ro_0900_as_cs 4
283 utf8mb4_sl_0900_as_cs 4
284 utf8mb4_pl_0900_as_cs 4
285 utf8mb4_et_0900_as_cs 4
286 utf8mb4_es_0900_as_cs 4
287 utf8mb4_sv_0900_as_cs 4
288 utf8mb4_tr_0900_as_cs 4
289 utf8mb4_cs_0900_as_cs 4
290 utf8mb4_da_0900_as_cs 4
291 utf8mb4_lt_0900_as_cs 4
292 utf8mb4_sk_0900_as_cs 4
293 utf8mb4_es_trad_0900_as_cs 4
294 utf8mb4_la_0900_as_cs 4
296 utf8mb4_eo_0900_as_cs 4
297 utf8mb4_hu_0900_as_cs 4
298 utf8mb4_hr_0900_as_cs 4
300 utf8mb4_vi_0900_as_cs 4
303 utf8mb4_ja_0900_as_cs 4
304 utf8mb4_ja_0900_as_cs_ks 4
305 utf8mb4_0900_as_ci 4
306 utf8mb4_ru_0900_ai_ci 4
307 utf8mb4_ru_0900_as_cs 4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Development

No branches or pull requests

1 participant