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?
Retrieving data ...