Kbase P111827: Turkish character incorrectly sorted/returned by index function
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/29/2005 |
|
Status: Unverified
SYMPTOM(s):
Turkish character incorrectly sorted/returned by index function
Index function does not work with Turkish dotless 'i'
The INDEX function returns the incorrect position of the Turkish dotless 'i' in a string.
The Unicode client and ICU-tr collations do not handle the Turkish dotless 'i' correctly.
REPLACE function does not work with Turkish dotless 'i'.
FIX:
Use the COMPARE function to work around the problem. For example:
MESSAGE
COMPARE("i", '=', CHR(253,"utf-8","1254"), 'CASE-SENSITIVE', "BASIC") SKIP
COMPARE("i", '=', CHR(253,"utf-8","1254"), 'CASE-SENSITIVE', "ICU-tr").