CCSID Conversion Tool

When tables were created through JD Edwards World software, half of the alpha columns in the tables were flagged with CCSID 65535. Prior to Release 9.1, JD Edwards EnterpriseOne handled these columns with the Translate and Do Not Translate ODBC data sources. Tables in a Translate ODBC data source used IBM Client Access translation algorithms to translate data from EBCDIC to ASCII when reading from a server, and translate from ASCII to EBCDIC when writing to the server. Processes running on the server (CallObj Kernel; UBEs) did not need to do translations as they were running in EBCDIC and the date was stored in EBCDIC.

JD Edwards EnterpriseOne 9.2 uses algorithms similar to the Client Access algorithms, provided by IBM as part of SQL on the server, to translate from the country-specific code page (for example, 37 for USA English) to Unicode. The JD Edwards EnterpriseOne code base in 9.2 is Unicode and all strings and characters must be translated to Unicode before passing them into the Release 9.2 code base. The IBM algorithms will NOT translate any columns flagged with CCSID 65535. Therefore, the CallObj Kernels and UBEs would not be able to read alpha data from these tables.