Hello

I am using FireBird 1.5, I created the database with UNICODE_FSS, I
have written/retrieved to/from the Database Macedonian characters with
no problem, but when I want to make a search using CONTAINING, I don't
get any results back if I search with Macedonian words.

My query is something like this:

SELECT * FROM ITEMS WHERE NAME CONTAINING 'Ал';

And I am certein I have words in this field having these letters.
Actually, I can use any letters, it never returns something. Except
when I search with empty string, then I get all back.

Shuld I do something specific for this query to work? I am not sure
now do I on connection specify UNICODE_FSS, if this could be one of
the reasons. But, I am sure that if I use equal in the query and
specify the exact word, it finds it. For example:

SELECT * FROM ITEMS WHERE NAME = 'Алва';

Any help?

Thanks,
Goran