This is the image which i have try to work but not working this, so please help me.
Asked
Active
Viewed 35 times
-2
-
show your code which try ? other wise we can not help properly – Shafiqul Islam Dec 26 '17 at 08:42
-
Hi, which code are you refering to ? the eclipse ones works perfectly until certain emoji is being place in – Vic Chew Dec 26 '17 at 09:44
1 Answers
0
character_set_client/connection/results are the three that need to be set to utf8mb4 so that INSERTs and SELECTs handle full UTF-8 to/from the clients.
And you need utf8mb4 for Emoji and some of Chinese; utf8 will not suffice.
Rick James
- 135,179
- 13
- 127
- 222
-
i've tried many ways online t set those 3 to utf8mb4 but it doens't work – Vic Chew Jan 03 '18 at 04:49
-
Right after connecting, do `SET NAMES utf8mb4`. Note: user=root ignores `init_connect` in `my.cnf`. – Rick James Jan 03 '18 at 13:56