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

2019-05-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 QA Administrators changed: What|Removed |Added Ever confirmed|1 |0

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

2019-05-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #24 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing

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

2019-05-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #23 from Tim --- (In reply to Tim from comment #21) > Thanks! And I've just found out that another bug I've posted seems to have > something to do with this one! > > The other bug is that after I time opening, writing,

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

2019-05-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #22 from Tim --- Another observation: New Firebird embedded Base I can go to Edit -> Database -> Advanced Settings... In migrated from hsqldb I go to Edit -> Database and then all options are in gray and can't access

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

2019-05-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #21 from Tim --- Thanks! And I've just found out that another bug I've posted seems to have something to do with this one! The other bug is that after I time opening, writing, editing Writer files, if I open one of my data

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

2019-05-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #20 from Alex Thurgood --- @Tim : thanks ! The SCRIPT file for the embedded hsqldb reads as follows: SET DATABASE COLLATION "Spanish" CREATE SCHEMA PUBLIC AUTHORIZATION DBA CREATE CACHED TABLE "Library"("ID" INTEGER

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

2019-05-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #19 from Tim --- Created attachment 151701 --> https://bugs.documentfoundation.org/attachment.cgi?id=151701=edit Data base wrong sort Data base sample requested to find out the reason for not sorting in proper order after

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

2019-05-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 Alex Thurgood changed: What|Removed |Added See Also||https://bugs.documentfounda

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

2019-05-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #18 from Alex Thurgood --- Reading bug 116935, I see that there is already a request for COLLATION options to be offered at the UI level... this implies that a DDL statement to create a collation at table/field level works.

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

2019-05-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #17 from Alex Thurgood --- See also: http://www.firebirdtest.com/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-collation.html#fblangref25-ddl-tbl-collatcrt for CREATE COLLATION statements. If I

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

2019-05-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 Alex Thurgood changed: What|Removed |Added Ever confirmed|0 |1

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

2019-05-24 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #15 from Stang --- @Tim You did not comprehend the information presented in the post and links in all answers. The information in the post does explain what you observe. If continued lack of understanding, please ask under

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

2019-05-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #14 from Tim --- Created attachment 151549 --> https://bugs.documentfoundation.org/attachment.cgi?id=151549=edit Sort test I've found a sample I attach (Sort_Test) and both Query1 and Query2 do it well, and only Query2 has

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

2019-05-19 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #13 from Stang --- @Tim see the answers in the following to set 'collate': https://ask.libreoffice.org/en/question/191187/sorting-in-base-with-german-umlaute/ -- You are receiving this mail because: You are the assignee

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

2019-05-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 QA Administrators changed: What|Removed |Added Ever confirmed|1 |0

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

2019-05-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #12 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing

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

2019-05-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #11 from Tim --- Is there anything I can do to solve this? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list

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

2019-05-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #9 from Tim --- Is there anything I can do to solve this? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list

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

2019-05-18 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #9 from Tim --- Is there anything I can do to solve this? --- Comment #10 from Tim --- Is there anything I can do to solve this? -- You are receiving this mail because: You are the assignee for the

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

2019-03-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #8 from Lionel Elie Mamane --- This definitely looks like the collation set on the database/table/field is not the one that the user would find useful. Looks like a NONE/OCTETS/ASCII/UNICODE collation, while user would like

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

2019-03-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 Xisco FaulĂ­ changed: What|Removed |Added CC||xiscofa...@libreoffice.org ---

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

2019-03-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 Alex Thurgood changed: What|Removed |Added Summary|Base - incorrect ASC order |Base - incorrect ASC order

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

2019-03-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #6 from Tim --- (In reply to Tim from comment #4) > (In reply to Alex Thurgood from comment #2) > > In a directly created embedded firebird ODB file, I see the following in a > > simple form created via the wizard : > > > >

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

2019-03-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #5 from Tim --- (In reply to Alex Thurgood from comment #3) > Perhaps the migration code sets a specific collation that doesn't match the > one that the user set under hsqldb ? > > Without a sample hsqldb with which to try a

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

2019-03-14 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #4 from Tim --- (In reply to Alex Thurgood from comment #2) > In a directly created embedded firebird ODB file, I see the following in a > simple form created via the wizard : > > AAA > AAa > Aaa > BBB > BBb > CCC > CCc > >

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

2019-03-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 Alex Thurgood changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0

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

2019-03-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #2 from Alex Thurgood --- In a directly created embedded firebird ODB file, I see the following in a simple form created via the wizard : AAA AAa Aaa BBB BBb CCC CCc That seems correct to me. Reading the documentation, it

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

2019-03-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 Alex Thurgood changed: What|Removed |Added Summary|Base ASC order in Form |Base - incorrect ASC order