https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #6 from Gerhard Schaber ---
Well, a workaround would be to use UPPER (only works due to the case
insensitive collation):
SELECT * FROM "MitgliederVerband" WHERE "Vorname" LIKE UPPER('Ö%')
--
You are receiving this mail
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #5 from Gerhard Schaber ---
SELECT * FROM "MitgliederVerband" WHERE "Vorname" LIKE 'Ö%' COLLATE
UNICODE_CI_AI
does not work, either, because the default character set seems to be NONE.
--
You are receiving this mail
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #4 from Gerhard Schaber ---
It only seems to happen, if there is an index on that column:
CREATE INDEX "mverbvorname" ON "MitgliederVerband"("Vorname")
In that case I can reproduce it with a blank new DB. Just create the
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #3 from Gerhard Schaber ---
It must be something related to the Ö at the beginning of the search string. It
also fails with search string 'Ö%':
SELECT * FROM "MitgliederVerband" WHERE "Vorname" LIKE 'Ö%'
--
You are
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #2 from Gerhard Schaber ---
Tested with 6.2.1.0 pre-release and 6.1.4.
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
https://bugs.documentfoundation.org/show_bug.cgi?id=123150
--- Comment #1 from Gerhard Schaber ---
The SDB table was originally created this way:
CREATE TABLE "MitgliederVerband"("ID" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"Vorname" VARCHAR(250) CHARACTER