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

2023-06-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #30 from Robert Großkopf --- Isn't this one a feature request? There should be executed ALTER CHARACTER SET UTF8 SET DEFAULT COLLATION UNICODE directly after a new Firebird database has been created. Have forgotten this in

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

2023-03-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 Robert Großkopf changed: What|Removed |Added Blocks||154426 Referenced Bugs:

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

2022-01-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #29 from bugreport...@protonmail.com --- Tools/SQL ALTER CHARACTER SET UTF8 SET DEFAULT COLLATION UNICODE changes the collation for new tables to UNICODE, but not for existing tables. -- You are receiving this mail

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

2022-01-16 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #28 from bugreport...@protonmail.com --- (In reply to Alex Thurgood from comment #16) > As the default behaviour under Firebird is different to hsqldb, the way to > workaround this is to: > > - either set the collation at the

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

2020-03-27 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #27 from Tim --- (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

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

2019-07-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 Robert Großkopf changed: What|Removed |Added See Also||https://bugs.documentfounda

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

2019-07-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 Robert Großkopf changed: What|Removed |Added OS|Mac OS X (All) |All -- You are receiving

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

2019-06-28 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 Xisco Faulí changed: What|Removed |Added Blocks||51780 Referenced Bugs:

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

2019-06-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 --- Comment #26 from Robert Großkopf --- (In reply to Robert Großkopf from comment #25) > This data will be sorted by a query: > SELECT "Name" FROM "Table" ORDER BY "Name" ASC > It will be shown the same way as sorted above: Capital

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

2019-06-17 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=124054 Robert Großkopf changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0