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