Hello

I'm using Firebird version 1.5.1.4481.
The database's charset is UNICODE_FSS.

The database has a table named PARENT with the following structure:
CREATE TABLE PARENT (
PARENT_ID INTEGER NOT NULL,
PARENT_NAME VARCHAR(200),
PARENT_DATE TIMESTAMP
);
the table has around 300 records.

I have inserted a record with Parent_Name = 'NIÑO'.
When I execute a select like:
select * from parent where parent_name like 'NIÑ%';
the firebird uses 100% cpu resources and never ends.

if I execute the following select:
select * from parent where parent_name = 'NIÑO';
everything works ok.

I have tested same behavior in other server (intel with dual pentium
IV) and
another databases structures (always with charset UNICODE_FSS and like
'somethingÑ%').

Any clue to solve this problem?

Thanks in advance.
Mauricio Magni.