Hello All,

I need collate iso8859-1 CASE INSENSITIVE and translate chars áâã to a, and éê to e, and ç to c, etc.

Look Bellow:

TABLE: TESTE
ID NAME
---- -------------------------------
1 José
2 João dos Santos

When i run:
a) SELECT ID, NAME FROM TESTE WHERE NAME LIKE '%josé%';
Return no records
b) SELECT ID, NAME FROM TESTE WHERE NAME LIKE '%José%'
Return records.

I need run SELECT ID, NAME FROM TESTE WHERE NAME COLLATE <???> = '%jose%', i like the firebird returns rows containing: 'josé', 'José', 'Jose', 'JOSE'.
The Collate <???> Exists?


Sorry my poor English, I'm studding!
I from Brazil:D


Thanks.