What is ccsid 37

But maybe someone else can chime in because there are probably some rare cases where you can have issues. Comment Post Cancel. We made that change and had no issues. Thanks, Emmanuel. One of our software vendors said it would cause a problem for their software although they couldn't really explain why so we have not done it.

We are living with it ok, but I would rather have it at All the reading I've done on it seems to indicate that I can do it safely, and everyone here seems to have had no issues, so now I'm tempted again Barbara Morris. September 15, , PM. It was on the first page of hits. Scott Klement. I guess it depends on how you use your system, but for most people it would be very unlikely that changing the CCSID to the proper value would cause a problem.

Now the system thinks the data is using the italian character set, but the data stored in the field is actually using the US character set. It'll put US hex values into the field, and read them still as hex values.

When you set up your QCCSID value properly to 37, however, characters start being translated because you've enabled the proper behavior. Unless something is set up wrong like that, it won't cause problems. Indeed, it'll fix problems, since now it'll properly identify things and translate them.

Allowing the use of things like Unicode in SQL, for example. In the unlikely event that there is a problem, the problem should be identified and fixed rather than disabling CCSID support which is, essentially, what does. Unfortunately, on this platform people can never turn down the chance to do things backward.

September 16, , AM. Thanks, everybody. In most respects these code pages are the same, but there are a few significant differences. These are referred to as the invariant character set.

This allows most text to be displayed without change, but means that some characters can be displayed incorrectly if there is inconsistency between data, job, and device. CDRA is a method of ensuring that text data appears as it was intended. To accomplish this, the operating system is "aware" of language attributes in data and jobs. Output devices like display stations and printers typically support one character set.

For example printers in North and South America and much of Europe support character set In the device description for a display there are attributes related to language. The Keyboard language type identifies the keyboard layout. The Character Identifier gives the character set and code page supported by the device. In the following figure, the device is set up for the United States and Canada. Each user job has attributes related to language. In the following figure, the job is setup for the U.

The biggest change from national to multinational is that data files are coded to support CCSID conversion. Language data is contained within files in JD Edwards World. For example, file F contains text for the menus. One of the keys to this file is language. Most text characters need no conversion, because they are in the invariant character set. There are some characters that do require conversion. The operating system handles this on input and output operations.

Therefore the character is assigned to hex code '49'.