te puede servir esto
Firebird 2.1.2 and UNICODE_CI
Starting with Firebird 2.1.2 (or earlier, at least 2.1.2 is what the Release Notes seem to tell), you can use a new Case Insensitive Collation named UNICODE_CI for the UTF8 character set (Unicode).
So when your default character set is UTF8, your table declaration might look like this:
CREATE TABLE PERSONS (
PERS_ID INTEGER NOT NULL PRIMARY KEY,
LAST_NAME VARCHAR(50) COLLATE UNICODE_CI,
FIRST_NAME VARCHAR(50) COLLATE UNICODE_CI
);
Your Index is a regular index declaration without any specials:
CREATE INDEX IDX_PERSON_LASTNAME ON PERSONS (LAST_NAME);
And your search expressions need no UPPER or whatsoever:
SELECT * FROM PERSONS WHERE LAST_NAME = :SEARCH_STRING
That's it.
lo tome de aqui
http://www.destructor.de/firebird/ca...tivesearch.htm
lo que seria bueno es poder hacer ambas cosas
con un checkbox. habilitado
hacer busqueda sensible mayusculas minusculas, y acentos
y sin habilitar que la busqueda sea case sensitive.