LO 6.2.3, Win 10, german version
There are 2 issues with sorting in Base under new firebird embedded.
The issues are related to all parts of base: tables, queries, forms and reports.
It´s after I converted a database from HSQLDB to firebird.
- Now sorting with german “Umlaute” (ä,ö,ü) in textfields is not regular on my system under firebird (it´s different to HSQLDB).
HSQLDB: a ä b c o ö z
Firebird : a b c o z ä ö
Firebird always sorts the Umlaute to the end of the list (incorrect), HSQLDB ist correct.
- Sorting of capital letters:
Firebird always sorts uppercases before lowercases, HSQLDB ignores this and sorts both types identical
HSQLDB: a b N M r s
Firebird : N M a b r s
Is there a way to let firebird sort like HSQLDB?