[Libreoffice-bugs] [Bug 124054] FIREBIRD: incorrect ASC order with varchar data

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124054

--- Comment #27 from Tim <woodford at pobox.com> ---
(In reply to Robert Großkopf from comment #25)
> The order of characters is Firebird-specific. I have changed the title for
> this.
> 
> Note: Has nothing to do with migration, it is the default behaviour of a new
> created database in LO 6.3.0.0.beta1:
> 
> Create a new database
> Create a table with ID - INTEGER (primrary key), "Name" - VARCHAR
> Input some data:
> 1  Aaa
> 2  Ba
> 3  Za
> 4  ab
> 5  ca
> 
> This data will be sorted by a query:
> SELECT "Name" ORDER BY "Name" ASC
> It will be shown the same way as sorted above: Capital letters first.
> SELECT "Name" ORDER BY "Name" COLLATE UNICODE ASC
> It will only work in direct SQL, so unusable for input data. But it will
> order "Name" as the order will be in HSQLDB:
> Aaa
> ab
> Ba
> ca
> Za
> 
> I could confirm this buggy behaviour with LO 6.3.0.0.beta1 on OpenSUSE 15,
> 64bit rpm Linux with a new created Firebird database.

Still the same behavior with LO 6.4.1.2 under MACOS with a new created Base
File using embeded Firebird.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200327/05e56d29/attachment.htm>