Firebird UTF-8 German phonebook sorting

2019-07-10 08:30发布

问题:

Server: Windows 2008 R2 x64 with Firebird 2.5 x64 I need a sorting methode like the German phonebook at a Query e.g.

SELECT Name, Forename FROM Address ORDER BY Name, Forename;

I want as result:

Name, Forename

  1. Assemann, Simon
  2. Aßmann, Erika
  3. Assmann, Frank
  4. Astmann, Manfred
  5. Hacker, Simon
  6. Hackmann, Gustav
  7. Häcker, Emil
  8. Haecker, Manfred
  9. Häcker, Xaver
  10. Hafermann, Ulrich

In the German phonebook sorting, the German special characters are handled at following way:

  • Ä/ä = Ae/ae
  • Ö/ö = Oe/oe
  • Ü/ü = Ue/ue
  • ß = ss

Other special characters like the French ones (á, à…) is handled like the normal characters (a,a…).

I’m trying du Upgrade the ICS*.dll from Version 3.0 to 5.0 or 5.6 but it doesn’t work.