You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2015-05-18 15:04:05

pixel.rajeshkannan
Member
8 posts

pixel.rajeshkannan said:

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

Tags: [oracle]

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?

Offline

#2 2015-05-19 04:14:41

xdshi
Talend Team


xdshi said:

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

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


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2015-05-19 10:39:28

pixel.rajeshkannan
Member
8 posts

pixel.rajeshkannan said:

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

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?

mini_image20.png 

Last edited by pixel.rajeshkannan (2015-05-19 10:42:20)

Offline

#4 2015-05-19 10:48:43

xdshi
Talend Team


xdshi said:

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

Hi,

Did you also add "-Dfile.encoding=utf-8" to the JVM parameters?

Best regards
Sabrina
mini_1.png_20150519-1148.png


What we can do is to make sure that Talend will be your best choice!

Offline

#5 2015-05-19 11:09:08

pixel.rajeshkannan
Member
8 posts

pixel.rajeshkannan said:

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

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

mini_image-21.png mini_image21.png

Last edited by pixel.rajeshkannan (2015-05-19 11:10:21)

Offline

#6 2015-05-19 11:27:46

xdshi
Talend Team


xdshi said:

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

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.

mini_1.png_20150519-1227.png


What we can do is to make sure that Talend will be your best choice!

Offline

#7 2015-05-19 12:04:03

pixel.rajeshkannan
Member
8 posts

pixel.rajeshkannan said:

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

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

Last edited by pixel.rajeshkannan (2015-05-19 12:04:48)

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy