0 Replies Latest reply on Dec 13, 2019 6:11 AM by Brennan Teh

    Amazon S3 v2 and file code page

    Brennan Teh New Member

      Hi All

       

      I have a source file with code page GB2312 (chinese simplified) located in Amazon S3.

       

      In the source transformation (Amazon S3 v2 connector), when I click formatting option, I could only see a few available codepages.

       

      My target is SQL Server (RDS) and current connection code page is Windows Latin-1.

       

      I tried all codepages from the Amazon S2 v3 connector, the Chinese character is still loaded incorrectly.

       

      Could you please advise what code page should I choose for Amazon S3 V2 connector and SQL server (RDS) in order to load the Chinese characters correctly?

       

      Thank You