Subject Re: [firebird-support] Cannot transliterate character between character sets
Author Helen Borrie
At 01:51 PM 8/04/2004 +0000, you wrote:
>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?!

Yes.
Some possibilities (as long as the .net provider is handling the input
correctly):

1. The column KUNDE is not in the default character set of the database.
2. The column KUNDE is in the default character set but the existing items
found by the search were entered in character set NONE (or some other
character set).
3. The column or domain uses a COLLATE attribute that excludes that character.

/heLen