goranburchevski wrote:

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

Goran,

I don't work with unicode charset, but I know that the International
Interface was re-written in FB 2.0 and that it has some bugs/limitations.

Could you try with the FB 2.0 beta and see if it works correctly ?

see you !

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