LMSouq
database Open

How to store Emoji Character in MySQL Database

SE
Selvamani P
1 month ago
3 views
Problem Description
I have a MySQL database configured with the default collation `utf8mb4_general_ci`. When I try to insert a row containing an emoji character in the text using the following query ```sql insert into tablename (column1,column2,column3,column4,column5,column6,column7) values ('273','3','Hdhdhdh😜😀😊😃hzhzhzzhjzj 我爱你 ❌',49,1,'2016-09-13 08:02:29','2016-09-13 08:02:29'); ``` MySQL is raising the following error > 1366 Incorrect string value: '\xF0\x9F\x98\x83\xF0\x9F...' for column > 'comment' at row 1

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base