Subject | Cannot transliterate character between character sets |
---|---|
Author | dthomas_ch |
Post date | 2004-04-09T00:04:34Z |
Following scenario:
WebService (C#) using the Firebird .NET Provider to query a Firebird
database. The default character set of the database is "ISO8859_1". I
am using following ConnectionString:
Database=CATERWARE.FDB;User=DT;Password=*****;Server=localhost;Charset
=ISO8859_1;"
I am getting the "Cannot transliterate character between character
sets" with queries like this one:
"update anlaesse set kunde = 'รถ' where anlassid = 1"
I tried to find some help on this, but all I found was this link:
http://community.borland.com/article/0,1410,29891,00.html - it says I
should have the same character set on the client as used by the
database. I assume the connection string sets the character set for
the client?!
WebService (C#) using the Firebird .NET Provider to query a Firebird
database. The default character set of the database is "ISO8859_1". I
am using following ConnectionString:
Database=CATERWARE.FDB;User=DT;Password=*****;Server=localhost;Charset
=ISO8859_1;"
I am getting the "Cannot transliterate character between character
sets" with queries like this one:
"update anlaesse set kunde = 'รถ' where anlassid = 1"
I tried to find some help on this, but all I found was this link:
http://community.borland.com/article/0,1410,29891,00.html - it says I
should have the same character set on the client as used by the
database. I assume the connection string sets the character set for
the client?!