|Subject||[firebird-support] RE: How do I get Danish collation with UTF8? -SOLVED|
|Author||Svein Erling Tysvær|
>>5: Using the syntaxI know nothing about Jacobs question, but why should he have to specify ACCENT SENSITIVE? In Danish and Norwegian the alphabet contains 29 characters, and the three mentioned characters are completely separate characters with their own distinctive sound, not accents of other characters - just like lowercase l is very different from uppercase I even though they may look similar or even identical depending on which font you use.
>>create collation UTF8_DANISH_CI for UTF8 from UNICODE CASE INSENSITIVE
>>create collation UTF8_DANISH_CS for UTF8 from UNICODE CASE SENSITIVE
>>doesn't give correct ÆØÅ sorting though... Hopefully that's fixed in FB 2.5.3 too.
>Did you try including the ACCENT SENSITIVE keyword in either example?
I don't use UTF8 myself, but Jacob could see if LOCALE = no_NO gave a better result, after all, we share the same alphabet.