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

EV89 — Mon, 03 Jul 2023 14:35:24 GMT

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

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

anselmopeixoto — Mon, 03 Jul 2023 14:59:23 GMT

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

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

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

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