云数据库 GAUSSDB(FOR MYSQL)-更新emoji表情数据报错Error 1366:场景描述

时间:2024-09-11 14:20:03

场景描述

业务插入或更新带有emoji表情的数据时,报错Error 1366。

java.sql.SQLException: Incorrect string value: '\xF0\x9F\x90\xB0\xE5\xA4...' for column 'username' at row 1 ;
uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366];  
Incorrect string value: '\xF0\x9F\x90\xB0\xE5\xA4...' for column 'username' at row 1; 
support.huaweicloud.com/trouble-gaussdbformysql/gaussdbformysql_trouble_0204.html