Niko, 'Parzival' parzival1...@gmx.at [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.
