I have issue where I am trying to migrate data from one oracle database into another oracle database using the Talend. Both databases have NLS_CHARACTERSET=AL32UTF8
Source table has name with French character. Talend is not converting it correctly when I use Studio.
I tried the following:
Updated Studio ini file with line
-Dfile.encoding=utf8
Try to add parameter in Job run - advance parameter
-Dfile.encoding=UTF-8
Columns in both source and target table is defined as column varchar2
I use tDBInput (Oracle) and tDBOutput (Oracle) components.
What do I need in order to convert this first name properly from one database table to another.
