ashish19977 opened a new issue, #33888: URL: https://github.com/apache/shardingsphere/issues/33888
[https://github.com/apache/shardingsphere/issues/13023] I have applied all the solutions mentioned above, but the problem still persists in my case. Sometimes it gives an error, and sometimes it works when I'm storing emojis. The issue gets resolved temporarily when I restart the proxy; after the restart, the error disappears for a while, but it reappears after some time. Once the error starts occurring, it continues to happen until I restart again. Here is my JDBC URL: jdbc:mysql://127.0.0.1:3306/portal-uat-1?allowPublicKeyRetrieval=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&character_set_server=utf8mb4&connectionCollation=utf8mb4_bin jdbc:mysql://127.0.0.1:3306/portal-uat2?allowPublicKeyRetrieval=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&character_set_server=utf8mb4&connectionCollation=utf8mb4_bin And here is my table schema: CREATE TABLE appt_data ( id int NOT NULL AUTO_INCREMENT, appointment_data longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, created_at datetime NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=28080676 DEFAULT CHARSET=utf8mb4; This schema is same across both the datasources. ### Which version of ShardingSphere did you use? - 5.4.1 ### Which project did you use? - ShardingSphere-Proxy ### Expected behavior - It should store emojies properly without failing Intermittently if column and tables's charset support emojies - in my case it is utf8mb4 COLLATE utf8mb4_bin -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
