It would be great to have support for UNICODE_CI and/or UNICODE_CI_AI collation for CHAR and VARCHAR fields in the UI. The character set UTF8 must be set automatically for those fields. For for new databases the global default character set is UTF8, now, anyway, if I am not mistaken. The collation could be provided as list to select from, or generally offered as VARCHAR_IGNORECASE field type, if that makes sense. I do not know the exact differences between a VARCHAR_IGNORECASE field in HSQLDB and a VARCHAR field with UNICODE_CI_AI or UNICODE_CI collation in Firebird.
Seems like a reasonable request. Confirming.
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'
It would be an important advantage, especially for the languages that use accented words