Kbase P92647: Is it possible to sort the Czech letter "ch" correctly ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/27/2004 |
|
Status: Unverified
GOAL:
Is it possible to sort the Czech letter "ch" correctly ?
GOAL:
How to sort the Czech letter "ch" after "h".
FIX:
The Czech alphabet contains the letter "ch". This letter is between letters "h" and "i". The Czech collation table can't handle this letter as "ch" and thus this letter is sorted as "c", which will results in "ch" being placed between "cg" and "ci".
The standard Progress / OpenEdge collations cannot handle two letter combinations such as "ch". However, the new ICU collations available in OpenEdge 10.0B do handle such issues, for example:
/******/
FOR EACH customer BY COLLATE(NAME,"CASE-INSENSITIVE","ICU-cs"):
DISPLAY NAME.
END.
/******/
Note that ICU collations can be used by the COMPARE function and COLLATE option even when cpinternal is not UTF-8.