Subject AW: [firebird-support] Use ISQL to insert special german characters
Author Parzival
Hello Thomas,

the change of chcp did the trick.



Gesendet: Mittwoch, 03. Juni 2015 09:02
Betreff: Re: [firebird-support] Use ISQL to insert special german characters


'Parzival' parzival1969@... [firebird-support] schrieb am 02.06.2015

> Hello all,
> for updating some tables at customers I create SQL scripts and execute
> with ISQL –i parameter. This works perfect unless I have to insert german
> special characters like äöüß.
> The database is set to ISO8859_1.
> Even when I set the charset with – charset for the command line parameter
> ISQL it still does not correctly write the ä etc. into the database.
> Any experience on this subject?

Do we talk about running isql on Windows?

I guess this is a matter of changing to a proper code page in the CMD shell
BEFORE running isql.

Try this in a DOS shell:

chcp (this gives you the currently active code page)
chcp 28591 (changes code page to ISO-8859-1, see also:

isql <database> <user> <pwd> -ch ISO8859_1

insert into t1 (...) values ('ä');
select * from t1;

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

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