mORMot Open Source

StraighFree

Member

Registered: 2025-06-07

Posts: 1

Collate for case insensitive in Firebird

Hello,

I’m studying the mORMot2 and its really great framework.

I created a small application that use a external database in Firebird to test the functionality and all works like a charm. Now, I need to implement the search in Firebird using case insensitive.

Could you please help me to understand how achieve that?

Thank you for amazing framework.

ttomas

Member

Registered: 2013-03-08

Posts: 143

Re: Collate for case insensitive in Firebird

Firebird related question, check documentation. In short create field with collation, something like

CREATE TABLE PERSONS (
  PERS_ID INTEGER NOT NULL PRIMARY KEY,
  LAST_NAME VARCHAR(50) COLLATE UNICODE_CI,
  FIRST_NAME VARCHAR(50) COLLATE UNICODE_CI
);

More details at https://firebirdsql.org/file/documentat … types.html