My Oracle Support Banner

E1: TC: Issue with Chinese Character Display in the *.CSV Output File (Doc ID 2482561.1)

Last updated on MARCH 16, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Table Conversion(TC) output is displaying garbage in the *CSV format for Chinese Characters?

Issue is verified with the following flat file encoding (like UTF-8, UTF-16LE etc) in P93081 application.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 #1 Open corrupted file in the hex editor to see if byte order mark (BOM) is added there, in this case it's not present
 #2 Open corrupted file in the Notepad and re-save with UNICODE encoding
 #3 Now open the newly saved file in the hex editor to check if encoding is added, and now its added in the first row of the file  as " FF FE"  i.e a representation of UTF-16E encoding
 4 Finally open newly created file to see the result and now it display Chinese characters properly
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.