Ad Widget

**Catwoolfii** · 07-08-2021, 09:57

I am using Zabbix-server 5.4.2 and MariaDB. After updating MariaDB from 10.5 to 10.6, this warning appeared:

Code:

Incorrect default charset for Zabbix database: "utf8mb4" instead "UTF8"

I have already encountered an database character problem when installing Zabbix-server, then I solved it by following this guide: https://www.zabbix.com/documentation...b_charset_coll
However, after updating the database to 10.6, I can't fix the character set and collation on database level. I think that MariaDB version 10.6 does not support charset utf8 and callation utf8_bin.
Here's what I see in the database:

Code:

MariaDB [(none)]> SHOW COLLATION LIKE 'utf8%';
+------------------------------+---------+------+---------+----------+---------+
| Collation | Charset | Id | Default | Compiled | Sortlen |
+------------------------------+---------+------+---------+----------+---------+
| utf8mb3_general_ci | utf8mb3 | 33 | Yes | Yes | 1 |
| utf8mb3_bin | utf8mb3 | 83 | | Yes | 1 |
| utf8mb3_unicode_ci | utf8mb3 | 192 | | Yes | 8 |
| utf8mb3_icelandic_ci | utf8mb3 | 193 | | Yes | 8 |
| utf8mb3_latvian_ci | utf8mb3 | 194 | | Yes | 8 |
| utf8mb3_romanian_ci | utf8mb3 | 195 | | Yes | 8 |
| utf8mb3_slovenian_ci | utf8mb3 | 196 | | Yes | 8 |
| utf8mb3_polish_ci | utf8mb3 | 197 | | Yes | 8 |
| utf8mb3_estonian_ci | utf8mb3 | 198 | | Yes | 8 |
| utf8mb3_spanish_ci | utf8mb3 | 199 | | Yes | 8 |
| utf8mb3_swedish_ci | utf8mb3 | 200 | | Yes | 8 |
| utf8mb3_turkish_ci | utf8mb3 | 201 | | Yes | 8 |
| utf8mb3_czech_ci | utf8mb3 | 202 | | Yes | 8 |
| utf8mb3_danish_ci | utf8mb3 | 203 | | Yes | 8 |
| utf8mb3_lithuanian_ci | utf8mb3 | 204 | | Yes | 8 |
| utf8mb3_slovak_ci | utf8mb3 | 205 | | Yes | 8 |
| utf8mb3_spanish2_ci | utf8mb3 | 206 | | Yes | 8 |
| utf8mb3_roman_ci | utf8mb3 | 207 | | Yes | 8 |
| utf8mb3_persian_ci | utf8mb3 | 208 | | Yes | 8 |
| utf8mb3_esperanto_ci | utf8mb3 | 209 | | Yes | 8 |
| utf8mb3_hungarian_ci | utf8mb3 | 210 | | Yes | 8 |
| utf8mb3_sinhala_ci | utf8mb3 | 211 | | Yes | 8 |
| utf8mb3_german2_ci | utf8mb3 | 212 | | Yes | 8 |
| utf8mb3_croatian_mysql561_ci | utf8mb3 | 213 | | Yes | 8 |
| utf8mb3_unicode_520_ci | utf8mb3 | 214 | | Yes | 8 |
| utf8mb3_vietnamese_ci | utf8mb3 | 215 | | Yes | 8 |
| utf8mb3_general_mysql500_ci | utf8mb3 | 223 | | Yes | 1 |
| utf8mb3_croatian_ci | utf8mb3 | 576 | | Yes | 8 |
| utf8mb3_myanmar_ci | utf8mb3 | 577 | | Yes | 8 |
| utf8mb3_thai_520_w2 | utf8mb3 | 578 | | Yes | 4 |
| utf8mb3_general_nopad_ci | utf8mb3 | 1057 | | Yes | 1 |
| utf8mb3_nopad_bin | utf8mb3 | 1107 | | Yes | 1 |
| utf8mb3_unicode_nopad_ci | utf8mb3 | 1216 | | Yes | 8 |
| utf8mb3_unicode_520_nopad_ci | utf8mb3 | 1238 | | Yes | 8 |
| utf8mb4_general_ci | utf8mb4 | 45 | Yes | Yes | 1 |
| utf8mb4_bin | utf8mb4 | 46 | | Yes | 1 |
| utf8mb4_unicode_ci | utf8mb4 | 224 | | Yes | 8 |
| utf8mb4_icelandic_ci | utf8mb4 | 225 | | Yes | 8 |
| utf8mb4_latvian_ci | utf8mb4 | 226 | | Yes | 8 |
| utf8mb4_romanian_ci | utf8mb4 | 227 | | Yes | 8 |
| utf8mb4_slovenian_ci | utf8mb4 | 228 | | Yes | 8 |
| utf8mb4_polish_ci | utf8mb4 | 229 | | Yes | 8 |
| utf8mb4_estonian_ci | utf8mb4 | 230 | | Yes | 8 |
| utf8mb4_spanish_ci | utf8mb4 | 231 | | Yes | 8 |
| utf8mb4_swedish_ci | utf8mb4 | 232 | | Yes | 8 |
| utf8mb4_turkish_ci | utf8mb4 | 233 | | Yes | 8 |
| utf8mb4_czech_ci | utf8mb4 | 234 | | Yes | 8 |
| utf8mb4_danish_ci | utf8mb4 | 235 | | Yes | 8 |
| utf8mb4_lithuanian_ci | utf8mb4 | 236 | | Yes | 8 |
| utf8mb4_slovak_ci | utf8mb4 | 237 | | Yes | 8 |
| utf8mb4_spanish2_ci | utf8mb4 | 238 | | Yes | 8 |
| utf8mb4_roman_ci | utf8mb4 | 239 | | Yes | 8 |
| utf8mb4_persian_ci | utf8mb4 | 240 | | Yes | 8 |
| utf8mb4_esperanto_ci | utf8mb4 | 241 | | Yes | 8 |
| utf8mb4_hungarian_ci | utf8mb4 | 242 | | Yes | 8 |
| utf8mb4_sinhala_ci | utf8mb4 | 243 | | Yes | 8 |
| utf8mb4_german2_ci | utf8mb4 | 244 | | Yes | 8 |
| utf8mb4_croatian_mysql561_ci | utf8mb4 | 245 | | Yes | 8 |
| utf8mb4_unicode_520_ci | utf8mb4 | 246 | | Yes | 8 |
| utf8mb4_vietnamese_ci | utf8mb4 | 247 | | Yes | 8 |
| utf8mb4_croatian_ci | utf8mb4 | 608 | | Yes | 8 |
| utf8mb4_myanmar_ci | utf8mb4 | 609 | | Yes | 8 |
| utf8mb4_thai_520_w2 | utf8mb4 | 610 | | Yes | 4 |
| utf8mb4_general_nopad_ci | utf8mb4 | 1069 | | Yes | 1 |
| utf8mb4_nopad_bin | utf8mb4 | 1070 | | Yes | 1 |
| utf8mb4_unicode_nopad_ci | utf8mb4 | 1248 | | Yes | 8 |
| utf8mb4_unicode_520_nopad_ci | utf8mb4 | 1270 | | Yes | 8 |
+------------------------------+---------+------+---------+----------+---------+

How critical is this for zabbix-server operation?