Subject Re: [firebird-support] Cannot transliterate character between character sets
Author Helen Borrie
At 12:26 PM 9/10/2005 +0000, you wrote:
>I created a database using the "UNICODE_FSS" charset,
>and I keep getting the following exception:
>"Cannot transliterate character between character sets"
>when I try to use hebrew characters in my query (in the where statement).
>Everything works fine when I use characters such as "É".
>does anyone know what's the right encoding that I need to use or what
>can be the problem?

Two questions:

1. Do you mean that you created the database with unicode_fss as the
default character set?

create database 'server:/path/to/databases/mydb.fdb' ...default character
set unicode_fss

2. If yes, are your clients connecting with unicode_fss in the lc_code