https://bugs.documentfoundation.org/show_bug.cgi?id=124054
--- Comment #38 from Robert Großkopf <[email protected]> --- (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. 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. -- You are receiving this mail because: You are the assignee for the bug.
