mysql数据库错误203,数据库错误（MySQL）

incorrect string value: \xF0\x9F\x92\x95

how to solve it? this happens when I enter product data

解决方案

The CHARACTER SET of the column needs to be utf8mb4. Please provide SHOW CREATE TABLE for confirmation.

Also, the connection needs to be utf8mb4 (or UTF-8, depending on the client language). Let's see the connection parameters.

Give a try with below solution.

I was finally able to figure out the issue.

I had to change some settings in mysql configuration my.ini

This article helped a lot

http://mathiasbynens.be/notes/mysql-utf8mb4#character-sets

First i changed the character set in my.ini to utf8mb4

Next i ran the following commands in mysql client

SET NAMES utf8mb4;

ALTER DATABASE dreams_twitter CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci;

Use the following command to check that the changes are made

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';