firebird character set iso88591 is not installed

This column will be filled by a trigger and search is done on the uppered Technique to create a 'shadow column' that will take the UPPERed text. Or it can be done when calling the UPPER() function: SELECT UPPER (LAST_NAME COLLATE DE_DE) FROM PERSONS Firebird 1.5Īs there is no way to build an index on a function call, it is a common Table: CREATE TABLE PERSONS ( PERS_ID INTEGER NOT NULL PRIMARY KEY, LAST_NAME VARCHAR(50) COLLATE DE_DE, In order to get correct results from the UPPER() function that is built intoįirebird, you must specify a collation. In my examples, this is the collation for German/Germany in the ISO8859_1 (You should know the concepts of Character Sets andĬollations in order to understand what comes next. Situation will hopefully improve over time. (July 2006) there are only two Czech AI/CI collations for Firebird 2.0.

In order to get really perfect results one would need a case insensitive (CI)Īnd/or accent insensitive (AI) collation. The technique described in this article will work best for European languages. NoteĪlso that there are languages/scripts where there is no such thing as case. Uppercasing has limitations, because some letters cannot be uppercased. So there must beĪ simple way to do case insensitive comparisons is to uppercase both stringsĪnd then compare the uppercased versions of both strings. 'PrESley', we always want to find the King.Īh yes, and we want that search to be fast, please. We want this search to be case insensitive, i.e. So the user inputs the last name of the person he Now there is an application, which allows the user to search for persons by Imagine you have a table of persons like this one: CREATE TABLE PERSONS ( PERS_ID INTEGER NOT NULL PRIMARY KEY, LAST_NAME VARCHAR(50), This article explains how to perform case insensitive searches using

Firebird character set iso88591 is not installed