[Libreoffice-bugs] [Bug 116935] Firebird: Support for collation in the UI

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Gerhard Schaber <gerhard.schaber at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180412/d341db3e/attachment.html>