One Star

Unable to write Multi byte Character(like Chinese/Japanese) to Oracle

Hi Team,
I want to read multibyte characters like Chinese/Japanese character from excel and insert into oracle database table. So what I did for this:

I have created database table with nvarchar2 datatype column for storing multibyte character.
Then I have created excel file in talend and able to see the data in preview.(or even able to see in logRow in console)
I am using tMap to join these two (excel and database table)
It is running successfully and inserting records into the table but the inserted data is junk character (not the actual one, even I exported the data from sql developer/plsql developer in excel but its junk)
Also I am using UTF-8 as a encoding style in talend Data integration 6.2.1 as well as in Oracle Database.

Is there anything I am missing ?
Thanks in advance.
Regards,
Rakesh D
1 REPLY
Moderator

Re: Unable to write Multi byte Character(like Chinese/Japanese) to Oracle

Hi,
Have you tried to add the "Dfile.encoding=utf-8" to the JVM parameters to see if it works?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.