Hello Martijn,
my impression was the other way arround ;-) When I change the charset in isql to any charset, that is definitly not used in the database I always get the same output from isql. I was expecting that the presentation of the same data (= varchar with special characters) would change in isql if I switch charset. Niko Von: [email protected] [mailto:[email protected]] Gesendet: Donnerstag, 19. Februar 2015 12:49 An: [email protected] Betreff: Re: [firebird-support] Charset in ISQL: How to show special characters Hi, Looks like ISQL is right and EMS SQL Manager is wrong. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! From: mailto:[email protected] Sent: Thursday, February 19, 2015 12:40 PM To: [email protected] <mailto:[email protected]> Subject: [firebird-support] Charset in ISQL: How to show special characters 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 Sttzen 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 [Non-text portions of this message have been removed]
