https://bugs.documentfoundation.org/show_bug.cgi?id=124054
--- Comment #39 from [email protected] --- (In reply to Robert Großkopf from comment #38) > (In reply to Mike Kaganski from comment #37) > > (In reply to Robert Großkopf from comment #36) > > > > But is the "dictionary" sorting the expected sorting here? Who told that? > > (Note that I do not claim it's OK - just need some rationale, beyond "some > > unrelated thing like dictionary has something else"). > > This is the essence of my comment 31: I do not see the actual problem here. > > If it is "the default collation of a new database / table / field should be > > X", it's one thing (and needs a discussion); > > This is the discussion here. The default collation is a collation no other > database with direct driver will use. It sorts in a way it is never expected > by a user. > Well, may be not other users, but me always expect capital letters before small letters, as was ordered in the ASCII table, which was the typical order used in computer science > Examples: HSQLDB sorts > a > A > b > B > > Same way of sorting for PostgreSQL and direct connection, same with > MySQL/MariaDB and direct connection. > > SQLite, connected by JDBC, will sort the same as internal Firebird. > Collation UNICODE won't show the same behavior as sorting in all other > databases with direct connection. It will set upper cases first and then > lower cases. But there is no other collation I tested for Firebird, which > would work with UTF8 ans sort the same way as all other databases will sort > with direct connection. Also, as ASCII, in the Unicode order, capital letters are placed before small letters, and both of them before accented letters, if you order them by their number code. -- You are receiving this mail because: You are the assignee for the bug.
