[서버 설정 변경]
character_set_client     = utf8mb4           
character_set_connection = utf8mb4           
character_set_database   = utf8mb4           
character_set_filesystem = binary            
character_set_results    = utf8mb4           
character_set_server     = utf8mb4           
character_set_system     = utf8              
collation_connection     = utf8mb4_unicode_ci
collation_database       = utf8mb4_unicode_ci
collation_server         = utf8mb4_unicode_ci

[테이블/컬럼 설정 변경]

ALTER DATABASE homestead CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Leave a Reply

Your email address will not be published. Required fields are marked *