Two new character sets that contain the Euro currency sign (€, Unicode U+20AC) are added: IS885915 and WIN1252.

To set the money format to the Euro currency symbol you must issue the following command:

Alternatively, you can set this value in the Ingres Visual Manager (IVM).

WIN1252 corresponds to Windows code page 1252 Latin 1. This is the common character set of most American and Western European Windows PCs, and includes the Euro sign. Users wishing to use the Euro symbol in a Windows GUI environment need to select the WIN1252 character set at installation time. To set this code page in a Windows command prompt environment, you must issue the following Windows command:

The default font in a Windows command prompt does not provide support for the Euro currency symbol. For a workaround, set the font to Lucida Console. The Lucida Console font has moved the line drawing characters, used in Ingres forms, into an area not accessible to Ingres binaries, so we have provided rudimentary line drawing in the IBMPCD terminal entry. To set this terminal type, you must either issue the following command:

IS885915 corresponds to the ISO 8859-15 Latin 9-character set that is almost identical to the ISO 8859-1 Latin 1 set, except for eight characters; chief among them is the Euro currency sign (€, Unicode U+20AC).

If you have an existing installation and would like to change the character set, be aware that this is not typically supported because the new character set could display existing characters in your databases incorrectly. However, since the ISO 8859-15 only has eight characters that are different from ISO 8859-1, if you can verify that none of the eight characters are already present in your databases, you could safely change the set (by changing II_CHARSETxx).

The following table details these differences and provides the corresponding Unicode character names: