RaigorJiang commented on issue #13023: URL: https://github.com/apache/shardingsphere/issues/13023#issuecomment-2518974430
> @RaigorJiang, 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-uat21?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 datasouces. @ashish19977 Is characterEncoding specified in the URL that your application uses to connect to Proxy? -- 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]
