java.sql.SQLException: Incorrect string value: '\xF0\x9D\x99\x88\xF0\x9D...' for column 'ship_receiverName' at row 1

[EV89]

Hi all,

i am tryng to save in mysql a field called ship_receiverName.

This field is downloaded with a rest api and extracted from a json but contains a bold string that send in error my sql

The error is the following

java.sql.SQLException: Incorrect string value: '\xF0\x9D\x99\x88\xF0\x9D...' for column 'ship_receiverName' at row 1

I attach the value that send in error the mysql insert (see errorFiedl attachment). Furthermore if i run the talend debug i cannot see as string this value in talend. i see only empty squares, what that mean (see emptySquares attachment)?

thanks for your help

[anselmopeixoto]

Hi @Elia Verga​ 

I believe you need to tweak some configs on your mysql database to support full Unicode.

Please take a look at this reference: https://stackoverflow.com/questions/23224512/incorrect-string-value-without-characterencoding-utf-8