You are right. I changed the connection charset to utf-8 and now it accepts non us charsets.
Pekka From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Mark Rotteveel Sent: 25. huhtikuuta 2014 11:38 To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] non us characters in comments fail On Fri, 25 Apr 2014 07:55:35 +0000, Pekka Paunio <pekka.pau...@newsbrokers.fi<mailto:pekka.pau...@newsbrokers.fi>> wrote: > Charset is UTF8 and Server version is 2.5.2. Is that your *connection* character set or your *database* character set? Also how are you executing this script? It is very easy for a tool to use the connection character set UTF-8, but then send bytes that are - for example - ISO-8859-1 which then leads to transliteration errors as there are byte combinations that are invalid UTF-8. An ä in ISO-8859-1 is byte 228 or 1110 0100 meaning the character consists of 3 bytes, this means this byte must be followed by two bytes with the two highest bits set to 10, however your ä is followed by a space (32 or 0010 0000) and an asterisk(*, 42 or 0010 1010) and so it is an invalid UTF-8 character! The same when you connect with connection character set NONE, the client sends the bytes as is and Firebird then tries to store it in UNICODE_FSS of the system table, this fails for the same reasons. Mark