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

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?


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