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



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!