Hi,
I'm getting the below error when writing a text value in the database:
java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x8A\x0A\x0A
I guess it is because of the column collation is "utf8_general_ci" and does not support unicode characters. I already tried changing the collation type to unicode but it still does not work.
Did anyone else face similar issue? Please suggest a solution.
TIA
Regards,
Sunil Zacharia
Discussion posts and replies are publicly visible
Do you want to save off non printable charaters in DB? If not, use clean() before saving into PV! and save off in DB.
If you want to save them off, can you try with utf8mb4?
utf8mb4?