[Libreoffice-bugs] [Bug 124054] Base - incorrect ASC order in Form with varchar data containing accented characters

[bugzilla-daemon at bugs.documentfoundation.org]

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

Alex Thurgood <iplaw67 at tuta.io> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEEDINFO

--- Comment #16 from Alex Thurgood <iplaw67 at tuta.io> ---
The real question to be answered, which may or may not be a bug, is that
either:

-  the Firebird migration assistant ignores any previously set collation with
the existing hsqldb table and sets a default collation which doesn't allow
sorting in the way people expect with hsqldb ;

or

- if no default collation was set with the existing hsqldb table, then the
Firebird default collation sort behaviour is applied.

As the default behaviour under Firebird is different to hsqldb, the way to
workaround this is to:

- either set the collation at the Query level escaping the built-in SQL parser
(run in direct SQL mode);

- or ALTER the table definition to add the required collation.


Currently, with the limited information Tim has provided, there is no way of
telling where the problem lies.

@Tim: as has been requested many times, we need a representative hsqldb ODB
file that displays the behaviour you describe so that we can examine whether it
is indeed the migration assistant that is not working correctly, or whether it
is just down to a difference in the way Firebird behaves compared to hsqldb in
the absence of any specified collation.

-- 
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/20190527/0b3d08f7/attachment-0001.html>