Subject Re: [ib-support] ISQL and national characters
Author Helen Borrie
At 01:17 PM 14-09-02 +0000, you wrote:
>I have a newly created database with Firebird 1.0 (build 796) on a
>linux box with the default character set ISO8859_1 and SQL dialect 3.
>If i try to insert records containing german umlauts from a sql script
>into a table, i get the error message -802 (cannot transliterate
>between character sets).
>The column type is based on a domain definition that contains the
>correct character set and collation information. The insert script
>does not contain any domain or character set information. SQL dialect
>3 is set on the client side.
>Is there any known issue in regard of inserting records from a script
>with ISQL into a Firebird database? Or am i doing anything wrong?

You have to set the character set at the client as well.
In isql (including in a script) the command is


The only alternative is to "cast" the input as ISO8859_1, e.g.

update Mytable set MyColumn = _ISO8859'Köln';