wgonzaless wrote:

> --- In firebird-support@yahoogroups.com, "William Gonzáles S."
> <wgonzaless@...> wrote:
>
>> Hello all.
>> The next SQL query:
>>
>> select * from MACHINES
>> where (DESCRIPTION like '%matríz%')
>>
>> or
>>
>> select * from MACHINES
>> where (UPPER(DESCRIPTION) like '%MATRÍZ%')
>>
>> does not give me any records, and there are many with
>> this condition in MACHINES table.
>> Mi database and DESCRIPTION field, have UNICODE_FSS
>> charset and I am using FB 1.5.3
>>
>>
>
> Hello, I forgot this:
> If I change the query to:
>
> select * from MACHINES
> where (UPPER(DESCRIPTION) like '%MATR%')
>
> (without 'ÍZ') it works fine, it seems that the spanish char is the
> problem.
>
> Thanks,
> William GS
>
>

William,

There are problems with UPPER and chars out of the ASCII 7 bits range IIRC.

FB 2.0 should have it fixed, could you look on it ?

There is a special version of FB called firebird PT_BR wich implements
an accent/case insensitive search/indices, so you could search for
Matriz, MATRÍZ, matríz, etc. and all will be equivalent.

you could found it on:

http://sourceforge.net/projects/firebirdptbr

I use it for some years without any trouble.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br