https://bugs.documentfoundation.org/show_bug.cgi?id=116935
--- Comment #2 from Gerhard Schaber <[email protected]> ---
As reference, this is a sample statement that creates a table with a case and
accent insensitive field:
CREATE TABLE "testcollation" (
"ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY
KEY, "name" VARCHAR(50) CHARACTER SET UTF8 COLLATE UNICODE_CI_AI
)
Then insert entries with upper and lower case characters
You will ten be able to query for all records case insensitively.
select * from "testcollation" where "name" = 'whatever'
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
