> Hi,

>> > 4. Unicode support

>> Yes it does. The only place where it's not fully supported and it's
>> when creating your WHERE clause, Firebird has a hard time coping with
>> the special characters in the search string. Other than that, it
>> works.

> ??? You can specify a character set for literals.

When using UNICODE_FSS for field definition and on connection, there's
a problem when trying to execute a simple query like "SELECT * FROM
CLIENTS WHERE FIRSTNAME LIKE 'é%'", where FIRSTNAME is of character
set UNICODE_FSS. The problem is that the server's CPU usage goes up
to 100% and stays there and the query never gets completed. There has
been a short discussion a few days ago in this group and another
longer a few months back. And, I also logged it in the bug tracker,
after the discussion a few months back.

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)