Áú»¢¶Ä²©

2 §£§à§ã§ã§ä§Ñ§ß§à§Ó§Ý§Ö§ß§Ú§Ö §ß§Ñ§Ò§à§â§Ñ §ã§Ú§Þ§Ó§à§Ý§à§Ó §Ú §ã§à§á§à§ã§ä§Ñ§Ó§Ý§Ö§ß§Ú§ñ §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç Áú»¢¶Ä²©

MySQL/MariaDB

1. §±§â§à§Ó§Ö§â§î§ä§Ö §ß§Ñ§Ò§à§â §ã§Ú§Þ§Ó§à§Ý§à§Ó §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç §Ú §ã§à§á§à§ã§ä§Ñ§Ó§Ý§Ö§ß§Ú§Ö.

§¯§Ñ§á§â§Ú§Þ§Ö§â:

mysql> SELECT @@character_set_database, @@collation_database;
       +--------------------------+----------------------+
       | @@character_set_database | @@collation_database |
       +--------------------------+----------------------+
       | latin2                   | latin2 _general_ci   |
       +--------------------------+----------------------+

§¬§Ñ§Ü §Þ§í §Ó§Ú§Õ§Ú§Þ, §ß§Ñ§Ò§à§â §ã§Ú§Þ§Ó§à§Ý§à§Ó §Ó §Ó§í§Ó§à§Õ§Ö - §ß§Ö 'utf8', §Ñ §ã§à§á§à§ã§ä§Ñ§Ó§Ý§Ö§ß§Ú§Ö -§ß§Ö 'utf8_bin', §á§à§ï§ä§à§Þ§å §ß§Ñ§Þ §ß§å§Ø§ß§à §Ú§ç §Ú§ã§á§â§Ñ§Ó§Ú§ä§î.

2. §°§ã§ä§Ñ§ß§à§Ó§Ú§ä§Ö Áú»¢¶Ä²©.

3. §³§à§Ù§Õ§Ñ§Û§ä§Ö §â§Ö§Ù§Ö§â§Ó§ß§å§ð §Ü§à§á§Ú§ð §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç!

4. §ª§ã§á§â§Ñ§Ó§î§ä§Ö §ß§Ñ§Ò§à§â §ã§Ú§Þ§Ó§à§Ý§à§Ó §Ú §ã§à§á§à§ã§ä§Ñ§Ó§Ý§Ö§ß§Ú§Ö §ß§Ñ §å§â§à§Ó§ß§Ö §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç:

alter database <your DB name> character set utf8 collate utf8_bin;

§ª§ã§á§â§Ñ§Ó§Ý§Ö§ß§ß§í§Ö §Ù§ß§Ñ§é§Ö§ß§Ú§ñ:

mysql> SELECT @@character_set_database, @@collation_database;
       +--------------------------+----------------------+
       | @@character_set_database | @@collation_database |
       +--------------------------+----------------------+
       | utf8                     | utf8_bin             |
       +--------------------------+----------------------+ 

5. §©§Ñ§Ô§â§å§Ù§Ú§ä§Ö , §é§ä§à§Ò§í §Ú§ã§á§â§Ñ§Ó§Ú§ä§î §ß§Ñ§Ò§à§â §ã§Ú§Þ§Ó§à§Ý§à§Ó §Ú §ã§à§á§à§ã§ä§Ñ§Ó§Ý§Ö§ß§Ú§Ö §ß§Ñ §å§â§à§Ó§ß§Ö §ä§Ñ§Ò§Ý§Ú§è§í §Ú §ã§ä§à§Ý§Ò§è§Ñ:

mysql <your DB name> < utf8_convert.sql

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;

§°§Ò§â§Ñ§ä§Ú§ä§Ö §Ó§ß§Ú§Þ§Ñ§ß§Ú§Ö, §é§ä§à §Ü§à§Õ§Ú§â§à§Ó§Ü§Ñ §Õ§Ñ§ß§ß§í§ç §ß§Ñ §Õ§Ú§ã§Ü§Ö §Ò§å§Õ§Ö§ä §Ú§Ù§Þ§Ö§ß§Ö§ß§Ñ. §¯§Ñ§á§â§Ú§Þ§Ö§â, §á§â§Ú §á§â§Ö§à§Ò§â§Ñ§Ù§à§Ó§Ñ§ß§Ú§Ú §ä§Ñ§Ü§Ú§ç §ã§Ú§Þ§Ó§à§Ý§à§Ó, §Ü§Ñ§Ü ?, ?, ? §Ú§Ù 'latin1' §Ó 'utf8' §à§ß§Ú §á§Ö§â§Ö§Û§Õ§å§ä §ã 1 §Ò§Ñ§Û§ä§Ñ §ß§Ñ 2 §Ò§Ñ§Û§ä§Ñ. §´§Ñ§Ü§Ú§Þ §à§Ò§â§Ñ§Ù§à§Þ, §Õ§Ý§ñ §Ú§ã§á§â§Ñ§Ó§Ý§Ö§ß§ß§à§Û §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç §Þ§à§Ø§Ö§ä §á§à§ä§â§Ö§Ò§à§Ó§Ñ§ä§î§ã§ñ §Ò§à§Ý§î§ê§Ö §Þ§Ö§ã§ä§Ñ, §é§Ö§Þ §â§Ñ§ß§î§ê§Ö.

7. §¦§ã§Ý§Ú §à§ê§Ú§Ò§à§Ü §ß§Ö§ä - §Ó§í §Þ§à§Ø§Ö§ä§Ö §ã§à§Ù§Õ§Ñ§ä§î §â§Ö§Ù§Ö§â§Ó§ß§å§ð §Ü§à§á§Ú§ð §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç §ã §Ú§ã§á§â§Ñ§Ó§Ý§Ö§ß§ß§à§Û §Ò§Ñ§Ù§à§Û §Õ§Ñ§ß§ß§í§ç.

8. §©§Ñ§á§å§ã§ä§Ú§ä§Ö Áú»¢¶Ä²©.