Hi all,

I am new to the group and not very expirienced with Firebird.
My question is about Unicode.
My table has several columns, defined as UNICODE_FSS.
When I insert data from Windows (which uses 'utf-16'), I convert it
to 'utf-8', the format, used by Firebird.
The data seems to be inserted correctly.
The question is - how can I use WHERE with Unicode characters.
If I simply pass a Unicode string (like Hebrew, Bulgarian, etc..) the
result contains ALL rows with Unicode characters.
ANd if I convert the string to UTF-8, FB returns results that have
nothing to do with the string passed in WHERE..
My DB has several columns, which must contain data in many languages
and I must be capable to search, based on string in these languages.

FB runs on Windows, and the application too.

Is there some special way to indicate that the string, passed in
INSERT and SELECT is Unicode? Or I am totally wrong in my aproach?

Thanks in advance!

Kiril Stankov.