Single/double bytes and character sets

[Alec_Turner]

I wonder if anyone can help us?

At the moment, our JDE environments come in an array of character
sets, and also in both single and double byte. We want to connect
Siebel 6.0.4 which is a global CRM application to all our JDE
boxes. At the moment we understand that Siebel can only support
Code page 1252 on a single-byte SQL platform.

We have two questions:

1. We've heard that JDE stores everything in a 'unicode' kind of
format in the back end, and that character set is largely just a
way for the Client to represent the Server data. However, this
can still lead to faulty characters appearing and in the case of
Russian, Greek or Arabic will often be garbage.

Is this actually the case, or is character set of great
importance to the data held on JDE? Would we be able to connect a
1252 character set PC to a Greek JDE box and retrieve meaningful
data?

2. Several of our double-byte implementations are actually run in
English, but are in double-byte to support certain languages
occupying the same environment, e.g. Korean. Would we be able to
connect a single-byte 1252 PC to a double-byte English JDE box
without an intermediate converter? If not, are converters
available which would do this exchange for us?

Any light you can shed on this would be greatly appreciated!

Thanks,

Alec JDE A7.3 Cum 10




[frown]

 

[tidiehl]

WorldSoftwareT does not use Unicode. WorldSoftwareT uses the iSeries
National Language Support (NLS) for character set translation. I believe
Unicode is planned for the next release of OneWorldR - ERP 9.

NLS requires careful hardware configuration because the CCSID (Coded
Character Set Identifier) can be defined at many different levels. I would
suggest you contact Support Line and ask to speak with one of the
specialists in the Technical Support Line area that specializes in NLS. They
have several people who are very knowledgeable in using different character
sets.

There is also a useful document "ccidwhitepaper" available on the Knowledge
Garden titled "J.D. Edwards World Software and IBM's AS/400 National
Language Support." You can access this by searching for NLS under the
Product area of the Knowledge Garden.

For more hardware information about IBM's National Language Support please
see the following books from IBM: AS/400 National Language Support and
AS/400 International Application Development.