duckdb-web icon indicating copy to clipboard operation
duckdb-web copied to clipboard

Issue found on page 'Utility Functions': ICU_SORT_KEY is not very clear

Open manticore-projects opened this issue 1 year ago • 0 comments

select icu_sort_key('ö', 'de')=icu_sort_key('o', 'de');
/* returns: FALSE */

select icu_sort_key('o', 'de:ci')=icu_sort_key('O', 'de:ci');
/* returns: FALSE */

I would have expected, that this example returns True since in German O and O-Umlaut have the same order? Also I am not clear how to get case insensitive Collators?

manticore-projects avatar Apr 12 '24 13:04 manticore-projects