mysql utf 8 mb 4文字化けし問題

mysql> SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%'; +--------------------------+-----------------------------------+ | Variable_name | Value | +--------------------------+-----------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir |/home/mysql/mysql/share/charsets/| | collation_connection | utf8_general_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +--------------------------+-----------------------------------+
表定義:mysql>SHOW CREATE DATABASE xxx;+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+|Database | Create Database | +------------------------+---------------------------------------------------------------------------------+ | xxx | CREATE DATABASE xxx /*!40100 DEFAULT CHARACTER SET utf 8*/|+---------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------++表フィールド定義utf 8 mb 4 CREATE TABLE xxx(id int(10)unsigned NOT NULL AUTO_INCREMENT COMMENT'自増id',content mediumtext COLLATE utf 8 mb 4_unicode_ci NOT NULL COMMENT'問題説明',)ENGINE=InnoDB AUTO_INCREMENT=3823 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT=''
ソリューション:
set names utf8mb4;(character_set_client character_set_serverをmb 4に設定します.)