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.