Documentation
Table of Contents
2 §£§à§ã§ã§ä§Ñ§ß§à§Ó§Ý§Ö§ß§Ú§Ö §ß§Ñ§Ò§à§â§Ñ §ã§Ú§Þ§Ó§à§Ý§à§Ó §Ú §ã§à§á§à§ã§ä§Ñ§Ó§Ý§Ö§ß§Ú§ñ §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç Áú»¢¶Ä²©
MySQL/MariaDB
§ª§ã§ä§à§â§Ú§é§Ö§ã§Ü§Ú, MySQL §Ú §á§â§à§Ú§Ù§à§Õ§ß§í§Ö §à§ä §ß§Ö§× §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§Ý§Ú 'utf8' §Ü§Ñ§Ü §ã§Ú§ß§à§ß§Ú§Þ §Õ§Ý§ñ utf8mb3 - §ã§à§Ò§ã§ä§Ó§Ö§ß§ß§Ñ§ñ 3-§Ò§Ñ§Û§ä§à§Ó§Ñ§ñ §â§Ö§Ñ§Ý§Ú§Ù§Ñ§è§Ú§ñ §Ü§à§Þ§Ñ§ß§Õ§à§Û §â§Ñ§Ù§â§Ñ§Ò§à§ä§é§Ú§Ü§à§Ó MySQL §ã§ä§Ñ§ß§Õ§Ñ§â§ä§Ñ UTF8, §Ü§à§ä§à§â§í§Û §ñ§Ó§Ý§ñ§Ö§ä§ã§ñ 4-§Ò§Ñ§Û§ä§à§Ó§í§Þ. §¯§Ñ§é§Ú§ß§Ñ§ñ §ã §Ó§Ö§â§ã§Ú§Ú MySQL 8.0.28 §Ú MariaDB 10.6.1, §ß§Ñ§Ò§à§â §ã§Ú§Þ§Ó§à§Ý§à§Ó 'utf8mb3' §ñ§Ó§Ý§ñ§Ö§ä§ã§ñ §å§ã§ä§Ñ§â§Ö§Ó§ê§Ú§Þ §Ú §Ó §Ü§Ñ§Ü§à§Û-§ä§à §Þ§à§Þ§Ö§ß§ä §Ö§Ô§à §á§à§Õ§Õ§Ö§â§Ø§Ü§Ñ §Ò§å§Õ§Ö§ä §á§â§Ö§Ü§â§Ñ§ë§Ö§ß§Ñ, §Ó §ä§à §Ó§â§Ö§Þ§ñ §Ü§Ñ§Ü 'utf8' §ã§ä§Ñ§ß§Ö§ä §ã§ã§í§Ý§Ü§à§Û §ß§Ñ 'utf8mb4'. §¯§Ñ§é§Ú§ß§Ñ§ñ §ã §Ó§Ö§â§ã§Ú§Ú Áú»¢¶Ä²© 6.0, §á§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§Ö§ä§ã§ñ 'utf8mb4'. §£§à §Ú§Ù§Ò§Ö§Ø§Ñ§ß§Ú§Ö §á§â§à§Ò§Ý§Ö§Þ §Ó §Ò§å§Õ§å§ë§Ö§Þ, §ã§ä§â§à§Ô§à §â§Ö§Ü§à§Þ§Ö§ß§Õ§å§Ö§ä§ã§ñ §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ä§î 'utf8mb4'. §¥§â§å§Ô§Ú§Þ §á§â§Ö§Ú§Þ§å§ë§Ö§ã§ä§Ó§à§Þ §á§Ö§â§Ö§Ü§Ý§ð§é§Ö§ß§Ú§ñ §ß§Ñ 'utf8mb4' §ñ§Ó§Ý§ñ§Ö§ä§ã§ñ §á§à§Õ§Õ§Ö§â§Ø§Ü§Ñ §Õ§à§á§à§Ý§ß§Ú§ä§Ö§Ý§î§ß§í§ç §ã§Ú§Þ§Ó§à§Ý§à§Ó §À§ß§Ú§Ü§à§Õ§Ñ.
§±§à§ã§Ü§à§Ý§î§Ü§å §Ó§Ö§â§ã§Ú§Ú Áú»¢¶Ä²© §Õ§à 6.0 §ß§Ö §Ù§ß§Ñ§ð§ä §à§Ò utf8mb4, §à§Ò§Ö§ã§á§Ö§é§î§ä§Ö §ã§ß§Ñ§é§Ñ§Ý§Ñ §à§Ò§ß§à§Ó§Ý§Ö§ß§Ú§Ö §ã§Ö§â§Ó§Ö§â§Ñ Áú»¢¶Ä²© §Ú §ã§ç§Ö§Þ§í §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç §Õ§à §Ó§Ö§â§ã§Ú§Ú 6.0.x, §á§â§Ö§Ø§Õ§Ö §é§Ö§Þ §Ó§í§á§à§Ý§ß§ñ§ä§î §á§Ö§â§Ö§ç§à§Õ §ß§Ñ utf8mb4.
1. §±§â§à§Ó§Ö§â§î§ä§Ö §ß§Ñ§Ò§à§â §ã§Ú§Þ§Ó§à§Ý§à§Ó §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç §Ú §ã§à§á§à§ã§ä§Ñ§Ó§Ý§Ö§ß§Ú§Ö.
§¯§Ñ§á§â§Ú§Þ§Ö§â:
mysql> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| latin2 | latin2 _general_ci |
+--------------------------+----------------------+§ª§Ý§Ú:
mysql> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| utf8 | utf8_bin |
+--------------------------+----------------------+§¬§Ñ§Ü §Þ§í §Ó§Ú§Õ§Ú§Þ, §ß§Ñ§Ò§à§â §ã§Ú§Þ§Ó§à§Ý§à§Ó §Ó §Ó§í§Ó§à§Õ§Ö - §ß§Ö 'utf8mb4', §Ñ §ã§à§á§à§ã§ä§Ñ§Ó§Ý§Ö§ß§Ú§Ö -§ß§Ö 'utf8mb4_bin', §á§à§ï§ä§à§Þ§å §ß§Ñ§Þ §ß§å§Ø§ß§à §Ú§ç §Ú§ã§á§â§Ñ§Ó§Ú§ä§î.
2. §°§ã§ä§Ñ§ß§à§Ó§Ú§ä§Ö Áú»¢¶Ä²©.
3. §³§à§Ù§Õ§Ñ§Û§ä§Ö §â§Ö§Ù§Ö§â§Ó§ß§å§ð §Ü§à§á§Ú§ð §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç!
4. §ª§ã§á§â§Ñ§Ó§î§ä§Ö §ß§Ñ§Ò§à§â §ã§Ú§Þ§Ó§à§Ý§à§Ó §Ú §ã§à§á§à§ã§ä§Ñ§Ó§Ý§Ö§ß§Ú§Ö §ß§Ñ §å§â§à§Ó§ß§Ö §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç:
§ª§ã§á§â§Ñ§Ó§Ý§Ö§ß§ß§í§Ö §Ù§ß§Ñ§é§Ö§ß§Ú§ñ:
mysql> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| utf8mb4 | utf8mb4_bin |
+--------------------------+----------------------+ 5. §©§Ñ§Ô§â§å§Ù§Ú§ä§Ö §ã§Ü§â§Ú§á§ä, §é§ä§à§Ò§í §Ú§ã§á§â§Ñ§Ó§Ú§ä§î §ß§Ñ§Ò§à§â §ã§Ú§Þ§Ó§à§Ý§à§Ó §Ú §ã§à§á§à§ã§ä§Ñ§Ó§Ý§Ö§ß§Ú§Ö §ß§Ñ §å§â§à§Ó§ß§Ö §ä§Ñ§Ò§Ý§Ú§è§í §Ú §ã§ä§à§Ý§Ò§è§Ñ:
6. §£§í§á§à§Ý§ß§Ú§ä§Ö §ã§Ü§â§Ú§á§ä:
SET @ZABBIX_DATABASE = '<your DB name>';
If MariaDB ¡ú set innodb_strict_mode = OFF;
CALL zbx_convert_utf8();
If MariaDB ¡ú set innodb_strict_mode = ON;
drop procedure zbx_convert_utf8;§°§Ò§â§Ñ§ä§Ú§ä§Ö §Ó§ß§Ú§Þ§Ñ§ß§Ú§Ö, §é§ä§à §Ü§à§Õ§Ú§â§à§Ó§Ü§Ñ 'utf8mb4' §Þ§à§Ø§Ö§ä §Ù§Ñ§ß§Ú§Þ§Ñ§ä§î §é§å§ä§î §Ò§à§Ý§î§ê§Ö §Þ§Ö§ã§ä§Ñ §ß§Ñ §Õ§Ú§ã§Ü§Ö, §é§Ö§Þ §â§Ñ§ß§î§ê§Ö.
7. §¦§ã§Ý§Ú §à§ê§Ú§Ò§à§Ü §ß§Ö§ä - §Ó§í §Þ§à§Ø§Ö§ä§Ö §Ù§Ñ§ç§à§ä§Ö§ä§î §ã§à§Ù§Õ§Ñ§ä§î §â§Ö§Ù§Ö§â§Ó§ß§å§ð §Ü§à§á§Ú§ð §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç §ã §Ú§ã§á§â§Ñ§Ó§Ý§Ö§ß§ß§à§Û §Ò§Ñ§Ù§à§Û.
8. §©§Ñ§á§å§ã§ä§Ú§ä§Ö Áú»¢¶Ä²©.