heLen, the column IS in the default character set for the database (i recreated the whole database from scratch with various different character sets, to see if any one would work). The database currently has only two records in it - they may have been entered with character set NONE, but would that make a difference for update queries? I did not define any collate attributes.

I will try working on point 2. on monday (i.e. recreate the database, making sure everything was added with the correct character set) but I don't believe it will help.

________________________________

Von: Helen Borrie [mailto:helebor@...]
Gesendet: Fr 09.04.2004 06:50
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Cannot transliterate character between character sets


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



Yahoo! Groups Sponsor
ADVERTISEMENT
click here <http://rd.yahoo.com/SIG=12clfqqq2/M=290828.4794622.5939935.1261774/D=egroupweb/S=1705115386:HM/EXP=1081572667/A=1950450/R=0/SIG=124u9bhid/*http://ashnin.com/clk/muryutaitakenattogyo?YH=4794622&yhad=1950450>


________________________________

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]