[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

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1
            Summary|Base - incorrect ASC order  |FIREBIRD: incorrect ASC
                   |in Form with varchar data   |order with varchar data
                   |containing accented         |
                   |characters                  |

--- Comment #25 from Robert Großkopf <robert at familiegrosskopf.de> ---
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.

-- 
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/20190617/fb49be09/attachment-0001.html>