Subject Re: [firebird-support] Re: Cannot transliterate character between character sets
Author Helen Borrie
At 01:09 PM 9/10/2005 +0000, you wrote:

>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");

Is this some magic trick of the db access interface you are using with
C#? If so, how does the database create structure get hold of the
hostname, directory path and filename of the database you create?


>and the client connects to it with the following connection string:
>
>Database=theFile;Charset=UNICODE_FSS;User=SYSDBA;Password=masterkey;Dialect=3;ServerType=1

Well, if your client is connecting with unicode_fss and its queries are
catching a character set mismatch with your stored data, it seems possible
that your database wasn't created with a default character set.

What can you see in isql when you do a SHOW DATABASE?

What mechanism was used to get the data into the database?

./heLen

p.s. I'm off to bed now, so hopefully someone else will pick this up for
you as dawn breaks over the opposite side of the world. :-)