Subject How do I get Danish collation with UTF8?




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!



(sorry if this is a repost. I just learned, that mails directly to the group don't show up in the web version of the list.)