Understanding Flat File Encoding
Because JD Edwards EnterpriseOne software uses Unicode and not all third-party software does, there is a preprocessing and postprocessing intercept of all flat files. During the intercept, the software converts the flat file into the Unicode character set or back into the original character set. You can assign the conversion character set applied to a flat file—based on the user or role, the program ID, the program version, and the environment—by adding and activating a flat file encoding record.
Using Unicode Flat File Encoding Configuration (P93081), you create records for a table that specifies what character sets are used for programs. The character sets are based on the user or role, the program ID, program version, and the environment. When the pre- or post-processing intercept occurs, the intercept program calls the table, searches it, and applies the record. The search is from more specific records to less specific records.
The primary users of Unicode Flat File Encoding Configuration are power users and system administrators. The business manager can provide the character set that is used to encode the third-party flat file.
Before setting up a flat file encoding record, you need to know the encoding of the flat file being transferred. You also need to know the user or role, program, program version, and environment that is calling the flat file.
To ensure that all files are encoded to the primary character set, set up a default flat file encoding record for the primary character set, and then add any exceptions. The system applies the more specific records before the more general records, so the default record is only used if no other records apply to the incoming flat file. If you do not add and activate a flat file encoding record, the default record is UCS2, UTF16_BE/UTF16_LS, which is a Unicode character set.
This table displays the character sets, from user defined code H95/FE, that are currently supported:
Code |
Description |
.ini Setting |
|---|---|---|
BIG5 |
Chinese, Traditional |
TC_BIG5 |
CP1250 |
WIN-Latin2, Central Europe |
EE_CP1250 |
CP1251 |
WIN-Cyrillic |
RS_CP1251 |
CP1252 |
WIN-Latin 1, Western European |
WE_ISO88591 |
CP1253 |
WIN-Greek |
GR_CP1253 |
CP1254 |
WIN-Latin5, Turkish |
TK_CP1254 |
CP1256 |
Win-Arabic |
AR_CP1256 |
GB2312 |
Chinese, Simplified |
SC_GB |
GB18030 (CS_GB18030) |
Chinese, National Standard Note: Table conversions can now export and import flat files in GB18030 encoding. |
|
IBM-1123 |
EBCDIC-Cyrillic |
RS-EBCDIC |
IBM-420 |
EBCDIC-Arabic |
AR_EBCDIC |
IBM-933 |
EBCDIC-Korean |
KO_EBCDIC |
IBM-935 |
EBCDIC-Simplified Chinese |
SC_EBCDIC |
IBM-937 |
EBCDIC-Traditional Chinese |
TC_EBCDIC |
IBM-939 |
EBCDIC-Japanese |
JA_EBCDIC |
IBM-37 |
EBCDIC-Latin 1 or Western Euro |
US_EBCDIC |
KSC-5601 |
Korean |
KO_KSC |
SHIFT_JIS |
WIN-Japanese |
JA_SJIS |
UCS2 |
UTF16_BE/UTF16_LE |
|
UTF-16LE |
UTF16_LE |
|
UTF-16BE |
UTF16_BE |
|
UTF8 |
UTF8 |
|
IBM-858 |
# PC Latin 1 with Euro |