Buscador PHP, un poco mas complejo

[JXJ]

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.