Hello Thomas,



the change of chcp did the trick.



Thanks



Niko



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





Niko,

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

> Hello all,
>
>
>
> for updating some tables at customers I create SQL scripts and execute

them

> 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

of

> 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:
https://msdn.microsoft.com/en-us/library/windows/desktop/dd317756%28v=vs.85%
29.aspx)

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

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

--
With regards,
Thomas Steinmaurer
http://www.upscene.com

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





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