Re: Importing UTF-8 multibytes file

Charles -

JDE World software can only handle one CCSID per environment - it does not
store the CCSID for a given record in the record itself. The system can be
customized to create the files with the CCSID particular to the country
language, but what I have seen mostly are CCSID(37) in the US and
CCSID(500) in western Europe.

Only one language/CCSID can be used in a given environment, but the
CCSID's used typically provide the basic English/Latin alphabetic
characters.

Files which can contain double-byte data are (DDS-created) with
CCSID(65535) at the field level and have Open fields defined for any
double-byte data such as names, descriptions, and addresses.

The 5250 sessions for a given environment are setup with the host code
page which corresponds to the CCSID of the language in use, so the jobs are
using the correct CCSID to present the data on screens.

Regards,
Steve

On Fri, Feb 4, 2022 at 8:31 AM Maria Lucia Stoppa <mlstoppa@xxxxxxxxx>

wrote:

In other words, are you telling me I can't, under any circumstances,
load these data into a DB2 65535-CCSID file?

Then Charles wrote:
You could, but then your application would have to handle all the

conversions,

the DB and it's various functions would be of no help.
Back before Unicode, applications like JD Edwards would store text
in a CCSID 65535 field along with the CCSID for that particular record...
Now, creating the table with UTF-8/UTF-16 columns is a much better way

to handle it.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com