--- 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