H. Features Introduced in Ingres 2.6 : New Character Sets to Support Euro Currency Symbol
 
Share this page                  
New Character Sets to Support Euro Currency Symbol
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:
ingsetenv II_MONEY_FORMAT L:€
Alternatively, you can set this value in the Ingres Visual Manager (IVM).
Windows:
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:
chcp 1252
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:
ingsetenv TERM_INGRES IBMPCD
or set TERM_INGRES through IVM or specify this terminal type at install time.
UNIX:
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:
Hex
 
ISO 8859-1
 
ISO 8859-15
A4
Currency symbol
Euro sign
A6
¦
Broken bar
Š
Latin capital letter with caron
A8
¨
Diaeresis
Š
Latin small letter with caron
B4
Acute accent
Ž
Latin capital letter Z with caron
B8
Cedilla
Ž
Latin small letter Z with caron
BC
¼
Vulgar fraction one quarter
Œ
Latin capital ligature OE
BD
½
Vulgar fraction one half
Œ
Latin small ligature oe
BE
¾
Vulgar fraction three quarters
Ϋ
Latin capital letter Y with diaeresis
Differences Between ISO 8859-1 and ISO 8859-15 Character Sets