Forgot to mention - I use the Version 1.2.1 of the FireBird OdbcJdbc
driver.

--- In firebird-support@yahoogroups.com, "salisburyproject"
<kiril@o...> wrote:

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