Kbase P185501: Nordic extended characters 'æ' = 'ä' are always equal.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/04/2011 |
|
Status: Unverified
SYMPTOM(s):
Nordic extended characters 'æ' = 'ä' are always equal.
MESSAGE 'æ' = 'ä' returns TRUE.
The region is Denmark, but the customer would prefer 'æ' = 'ä' to return FALSE.
FACT(s) (Environment):
Using -cpinternal 1252.
Using a collation setting -cpcoll Danish.
A collation must be chosen for all Nordic countries, Denmark, Sweden, Norway and Finland.
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
This is expected behavior. In Danish and Norwegian the characters 'æ' and 'ä' are the same and so with Danish and Norwegian collations, should be equal.
FIX:
A way to work around the problem would be to change the collation -cpcoll parameter to Basic, Swedish, Icelandic, or Finnish. All these collations will consider ä and æ to be different. Although this is also likely to affect the sort sequence of the rest of the characters.
Danish collation would be best suited for Danish users, but not for other regions like Norway and Sweden? So any choice would be a compromise. Basic collation is a basic English ASCII sort, so perhaps this is the best solution?
An alternative would be to create a new custom collation based on either Danish, Norwegian or Swedish. This could easily be done by just changing the sort weights for these two characters.