Kbase 20637: The Euro (€) Currency and Progress
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/03/2008 |
|
Status: Verified
GOAL:
This solution discusses the impact of the EURO on the functioning of Progress, and other industry changes that are being made.
FIX:
Although the introduction of the Euro impacts many areas of Progress development, it's impact on Progress is limited to the domain of codepages and related character set tables.
Most of the remaining changes to be made impact the operating system layer (for example, keyboard software and keycaps are updated to allow the generation of Euro characters, fonts for display and printing, etc.) and the applications layer (currency formats, financial calculations, currency conversion capabilities, reports, etc.).
New codepages are being created and existing codepages are being modified to support the Euro. Progress must to track these changes so that it processes the Euro character correctly. In particular, the convmap tables must be updated so that the value that is assigned to the Euro is treated properly as an alphabetic symbol, that it is sorted with other currency symbols, and that it is converted correctly when text is exchanged between codepages.
Microsoft and IBM have updated many codepages to include the Euro. Microsoft is not assigning new codepage names or otherwise indicating a revision of its codepage. IBM is creating new codepages.
ISO has recently voted to create a new codepage ISO 8859-15, that is also known as Latin 9. This codepage is similar to ISO 8859-1 with a handful of characters replaced by the Euro and a few others.
Some existing databases must be converted to a new codepage in order to make use of the Euro. Progress has modified the PROUTIL -C analyze function to assist you in identifying whether you have any characters in your database that are dropped when you convert from your existing codepage to the new one that contains the Euro. The utility now scans for a list of characters. The new function is executed by:
proutil <dbname> -C convchar charscan <CodePage to convert db to> "<list of character values>".
(More detail is available at the proutil -C convchar charscan specification.)
FIX:
References to Written Documentation:
Progress Solutions:
19626, "AS/400 Euro (?) Display Problem from a Progress Client"
19514, "Euro ? Supported and Equivalent non Euro Supported Codepages"
20638, "PROUTIL -C convchar charscan Functionality Explained"