Kbase P19014: German Library collation fails in Progress Version 8.x
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/07/2003 |
|
Status: Unverified
SYMPTOM(s):
Because of some issues with German collation table in
Progress Version 8.x, you must change from the German-library to
collation Basic.
CAUSE:
The primary purpose of the collation table is to provide the Progress
sorting algorithm with a sort weight for each character. The sort
weight determines the sort order for a character. The heavier the
character weight, the further down it falls in sort order.
In version 8.x there are several problems with German-Library sorting. For version 9 these problems have been corrected with German9 collation.
FIX:
Before making any of the following changes, have a good backup of your
database.
To change the sort order, you must modify the numeric values in the
table. You can also use the predefined .df files in the %DLC%\PROLANG
directory.
For example, the %DLC%\PROLANG\AME directory contains the American
specific .df files ame1252.df, ame850.df and ame88591.df with
collation Basic.
NOTE: You only have the subdirectories in the PROLANG directory of the
installed languages.
Follow these steps to change the collation:
1) Before you change the collation, you must know the correct
database code page. The database code page can be found in
Data Administration > Utilities > Information.
2) Depending on the database code page, choose:
- ame1252.df for database code page 1252
- ame850.df for IBM 850
- ame88591.df for ISO 8859-1 and similar for other
languages
3) Load this file into your database using Data Administration.
4) Run the PROUTIL idxbuild utility to rebuild indexes, otherwise
you cannot use the database.
The collation of your database is now changed.