User Guide : Encoding Reference : Determining Which Connector to Use : Example Use Case
 
Share this page             
Example Use Case
A company is using the integration platform to move data from a delimited ASCII format to an Oracle database. The company is expanding its markets to include East Asian languages. The delimited text documents are mainly in UTF-8 format and occasionally in Japanese EUC-JP and Chinese GB2312 encoding.
The following is the suggested approach that the company take:
Source: Unicode (Delimited)
Target: ODBC 3.5 (Oracle)
Install the East Asian Language package and select Install files for East Asian Languages.
The following are a few examples of the options you can set in Oracle.
Language Name
Language Type
Option
Simplified Chinese
LANG=zh_CN.GB2312
LC_ALL=zh_CN.GB2312
Traditional Chinese
LANG=zh_TW.BIG5
LC_ALL=zh_TW.BIG5
Japanese
LANG=ja_JP.eucJP
LC_ALL=ja_JP.eucJP
Korean
LANG=ko_KR.eucKR
LC_ALL=ko_KR.eucKR
For more details on how Oracle supports encoding, refer to the Oracle documentation.