At 01:17 PM 14-09-02 +0000, you wrote:

>Hi,
>
>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

SET NAMES ISO8859_1;

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

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

heLen