[firebird-support] Charset in ISQL: How to show special characters

Thu, 19 Feb 2015 03:45:35 -0800 

Hello,

 

due to an import problem the database contains some records with wrong
special characters.

 

The database runs on ISO8859_1. When I select the records in EMS SQL Manager
(also configured for ISO8859_1) it shows following data:

K”cher

Sttzen

Tr„ger

 

In ISQL (isql localhost:myDB -u SYSDBA -p 'blabla' -charset ISO8859_1) it
shows:

Köcher

Stützen

Träger

 

What needs to be done to get the same picture in isql as in the other tool?
The motivation is to fix such data with an isql script. In this case I don´t
get an matching records if query for

 

SELECT * FROM LPP_ISTSTUNDEN WHERE iststunden_code = 'K”cher';

 

Thanks

 

Niko

Reply via email to