https://bugs.documentfoundation.org/show_bug.cgi?id=116935

--- Comment #2 from Gerhard Schaber <gerhard.scha...@gmx.at> ---
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
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to