I have make sure that my mysql server configuration like character_set_server, collation_server, character_set_database, collation_database, character_set_client, character_set_connection, collation_connection was all configured as utf8mb4 and utf8mb4_0900_ai_ci, but when i try to add some emoji to my page, i got the exception below:
Caused by: java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x93\x9Eu …’ for column ‘XWR_PATCH’ at row 1.
And i can add emoji to mysql table directly, i guess that was caused by client connection, is there someway i can set the configuration like spring connectionInitSqls to “set names utf8mb4”?