Subject | Re: [firebird-support] Re: Cannot transliterate character between character sets |
---|---|
Author | Helen Borrie |
Post date | 2005-10-09T14:04:42Z |
At 01:09 PM 9/10/2005 +0000, you wrote:
C#? If so, how does the database create structure get hold of the
hostname, directory path and filename of the database you create?
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. :-)
>First of all, thanks for the quick responce.Is this some magic trick of the db access interface you are using with
>
>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");
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
>
>Database=theFile;Charset=UNICODE_FSS;User=SYSDBA;Password=masterkey;Dialect=3;ServerType=1
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. :-)