[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

--- Comment #14 from Tim <woodford at pobox.com> ---
Created attachment 151549
  --> https://bugs.documentfoundation.org/attachment.cgi?id=151549&action=edit
Sort test

I've found a sample I attach (Sort_Test) and both Query1 and Query2 do it well,
and only Query2 has the command COLLATE UNICODE asc to work under SQL command
directly!

But if I copy the Table and both Queries into one of my Database only Query2
will give the right order ASC.

I also tried the other way round, copy my tables and queries to the Sort-Test,
and the order only will be right using collate unicode under sql command
directly.

-- 
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/20190521/d43abf7a/attachment.html>