· 8 years ago · Jan 21, 2018, 09:26 PM
1SET NAMES utf8mb4; CREATE TABLE IF NOT EXISTS tbl_message message_message
2 VARCHAR(1000) DEFAULT CHARSET=utf8mb4;
3INSERT INTO 'tbl_message message_message VALUES ('Hello ðŸ¬');
4
5[client]
6default-character-set = utf8mb4
7
8[mysql]
9default-character-set = utf8mb4
10
11[mysqld]
12character-set-client-handshake = FALSE
13
14character_set_server=utf8mb4
15
16collation_server=utf8mb4_unicode_ci