Firebird UTF-8 German phonebook sorting

2019-07-10 07:54发布

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.

0条回答
登录 后发表回答