https://community.qlik.com/t5/Talend-Studio/Convert-Data-in-Oracle-with-French-Character/m-p/2313176#M84061 <P>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</P><P>Source table has name with French character. Talend is not converting it correctly when I use Studio.</P><P>I tried the following:</P><UL><LI>Updated Studio ini file with line</LI></UL><P></P><P> -Dfile.encoding=utf8</P><UL><LI>Try to add parameter in Job run - advance parameter</LI></UL><P> -Dfile.encoding=UTF-8</P><P></P><P></P><P>Columns in both source and target table is defined as column varchar2</P><P>I use tDBInput (Oracle) and tDBOutput (Oracle) components.</P><P></P><P></P><P>What do I need in order to convert this first name properly from one database table to another.</P><P>TIA</P><P></P><P></P><P></P><P></P> Sat, 16 Nov 2024 00:57:12 GMT sradovan 2024-11-16T00:57:12Z https://community.qlik.com/t5/Talend-Studio/Convert-Data-in-Oracle-with-French-Character/m-p/2313176#M84061 <P>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</P><P>Source table has name with French character. Talend is not converting it correctly when I use Studio.</P><P>I tried the following:</P><UL><LI>Updated Studio ini file with line</LI></UL><P></P><P> -Dfile.encoding=utf8</P><UL><LI>Try to add parameter in Job run - advance parameter</LI></UL><P> -Dfile.encoding=UTF-8</P><P></P><P></P><P>Columns in both source and target table is defined as column varchar2</P><P>I use tDBInput (Oracle) and tDBOutput (Oracle) components.</P><P></P><P></P><P>What do I need in order to convert this first name properly from one database table to another.</P><P>TIA</P><P></P><P></P><P></P><P></P> Sat, 16 Nov 2024 00:57:12 GMT https://community.qlik.com/t5/Talend-Studio/Convert-Data-in-Oracle-with-French-Character/m-p/2313176#M84061 sradovan 2024-11-16T00:57:12Z https://community.qlik.com/t5/Talend-Studio/Convert-Data-in-Oracle-with-French-Character/m-p/2313177#M84062 <P>Hello,</P><P>You may need to add an additional jdbc paramater: "noDatetimeStringSync=true&amp;characterEncoding=utf8".</P><P>Best regards</P><P>Sabrina</P> Wed, 16 Dec 2020 11:42:55 GMT https://community.qlik.com/t5/Talend-Studio/Convert-Data-in-Oracle-with-French-Character/m-p/2313177#M84062 Anonymous 2020-12-16T11:42:55Z