Hello Thomas,
the change of chcp did the trick. Thanks Niko Von: [email protected] [mailto:[email protected]] Gesendet: Mittwoch, 03. Juni 2015 09:02 An: [email protected] Betreff: Re: [firebird-support] Use ISQL to insert special german characters Niko, 'Parzival' [email protected] [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]
