topic Re: Incorrect string value: '\xC4\x90in\xC4\x91...' for column 'address' in Talend Studio

Incorrect string value: '\xC4\x90in\xC4\x91...' for column 'address'

Anonymous — Sat, 16 Nov 2024 11:13:11 GMT

Hi,
I am using Mysql Workbench. When I am trying to migrate the data from one database table to another database table I am getting this Error: Incorrect string value: '\xC4\x90in\xC4\x91...' for column 'address' at row 1.
In my source mysql database I am using "utf8" collation and the destination mysql database I am using "latin1" collation. I think it is the problem,but I don't know how to slove this problem. Need some Help. Is there I need to use any code for that?

Re: Incorrect string value: '\xC4\x90in\xC4\x91...' for column 'address'

Anonymous — Tue, 19 May 2015 04:14:41 GMT

Hi pixel.rajeshkannan,
Have you tried to set "Additional JDBC Parameter character Encoding=UTF-8" in advanced settings of tMysqlOutput and add the "-Dfile.encoding=utf-8" to the JVM parameters to see if it works?

Best regards
Sabrina

Re: Incorrect string value: '\xC4\x90in\xC4\x91...' for column 'address'

Anonymous — Tue, 19 May 2015 10:39:28 GMT

Hi,
I added the additiional jdbc parameter character Encoding=UTF-8 . But still I am getting this Error: Incorrect string value: '\xC4\x90in\xC4\x91...' for column 'address' at row 1. Is there any other option to slove this error?

Re: Incorrect string value: '\xC4\x90in\xC4\x91...' for column 'address'

Anonymous — Tue, 19 May 2015 10:48:43 GMT

Hi,
Did you also add "-Dfile.encoding=utf-8" to the JVM parameters?
Best regards
Sabrina

Re: Incorrect string value: '\xC4\x90in\xC4\x91...' for column 'address'

Anonymous — Tue, 19 May 2015 11:09:08 GMT

I also added the Dfile.encoding=utf-8" to the JVM parameters. Getting this error which is placed in the image.

Re: Incorrect string value: '\xC4\x90in\xC4\x91...' for column 'address'

Anonymous — Tue, 19 May 2015 11:27:46 GMT

Hi,
We don't get "Could not find or load main class " error after adding -Dfile.encoding=utf-8" into JVM setting. Here is "-" you are missing.

Re: Incorrect string value: '\xC4\x90in\xC4\x91...' for column 'address'

Anonymous — Tue, 19 May 2015 12:04:03 GMT

Hi,
Gettting the same error Incorrect String value . I added the "-Dfile.encoding=utf-8" in the component -> advanced setting and also Run job-> advanced settings.