--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

>
> At 12:26 PM 9/10/2005 +0000, you wrote:
> >Hi,
> >
> >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
> parameter?
>
> ./heLen
>

First of all, thanks for the quick responce.

I created the database programatically in C# with the following
parameters:
dbParameters.Add("User", "SYSDBA");
dbParameters.Add("Password", "masterkey");
dbParameters.Add("ServerType", "1");
dbParameters.Add("Charset", "UNICODE_FSS");

and the client connects to it with the following connection string:

Database=theFile;Charset=UNICODE_FSS;User=SYSDBA;Password=masterkey;Dialect=3;ServerType=1