SQL Exception Incorrect string value: '\xCE\xB2' fo

Posted by Meehl on 08-Feb-2018 11:32

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.

Rollbase - Forum

All Replies

Posted by Anoop Premachandran on 07-Mar-2018 02:57

Please change character set of table and columns in your database to UTF-8

Posted by Meehl on 07-Mar-2018 16:30

The character set is already set to UTF-8 and the document.characterSet query returns UTF-8.  

Posted by Manooj Murali on 08-Mar-2018 00:50

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

This thread is closed