Subject How do I get Danish collation with UTF8?
Author Jacob Havkrog

Hi-

 

The collation of special Danish characters ÆØÅ is not correct according to Danish standards when using UTF8. None of the supported collations sort Å after Æ and Ø.

 

Sorting should be is ÅÆØ but should be ÆØÅ with collation “UTF8” or “UCS_BASIC”. The other collations more wrong.

 

I use FB 2.5 on Windows x64.

 

I know there is something called custom collation but I can’t find any guide or examples, and it seems quite complicated considering its quite a basic requirement that national standards are supported.

 

Thanks for any help!

 

Jacob