[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 #20 from Alex Thurgood <iplaw67 at tuta.io> ---
@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 GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"BookID" INTEGER,"Title"
VARCHAR(100),"Author" VARCHAR(50),"Publisher" VARCHAR(50),"CoverType"
VARCHAR(50),"Pages" INTEGER,"PurchasedAt" VARCHAR(50),"DatePurchased"
DATE,"Rating" VARCHAR(50),"Notes" LONGVARCHAR,"YearRead" NUMERIC(4),"Genre"
INTEGER)
CREATE CACHED TABLE "G\u00e9nero"("ID" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"G\u00e9nero" VARCHAR(20))
ALTER TABLE "Library" ADD CONSTRAINT SYS_FK_87 FOREIGN KEY("Genre") REFERENCES
"G\u00e9nero"("ID")
SET TABLE "Library" INDEX'6432 7368 78'
SET TABLE "G\u00e9nero" INDEX'19184 13'
ALTER TABLE "Library" ALTER COLUMN "ID" RESTART WITH 78
ALTER TABLE "G\u00e9nero" ALTER COLUMN "ID" RESTART WITH 13
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 60

so at least we can confirm that collation is set in the file.

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