9 Replies Latest reply on Feb 14, 2019 3:10 PM by Rajan Rath

    Foreign Language character set loaded as "???" in oracle table

    vishal tickoo Active Member

      Hi All,

      When I'm loading data from Flat File having foreign characters present and loading it into Oracle database, foreign characters are not coming as expected instead coming as "???" or some other garbage characters.

      I have kept code page as "UTF-8" in both source file and target relational connection. The Integration Service "Data Movement Mode" is set to UNICODE and "Code Page" for Source & Target is also UTF-8.

      Please look into the issue and let me know if I'm missing out something.

       

      Thanks & regards,

      Vishal Tickoo