When portal users enter non-english characters such as the greek letter β in a text field and attempt to save the record, the system throws an "SQL Exception Incorrect string value: '\xCE\xB2' for column 'TXT39' at row 1" error.
I'd appreciate any advice about how to fix this error.
Thanks in advance.
Please change character set of table and columns in your database to UTF-8
The character set is already set to UTF-8 and the document.characterSet query returns UTF-8.
The character set to change to is "utf8mb4". Some supporting community links on similar issues:
stackoverflow.com/.../java-sql-sqlexception-incorrect-string-value-xf0-x9f-x91-xbd-xf0-x9f
thejavablog.wordpress.com/.../
MySQL guide on utf8mb4 - dev.mysql.com/.../charset-unicode-utf8mb4.html