Hi,

>my impression was the other way arround ;-)

Then I'm either misreading your e-mail, or you've switched the examples
around?

>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.

What application is show " ö " and what isn't? And is that valid?


With regards,

Martijn Tonies
Upscene Productions



Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Donnerstag, 19. Februar 2015 12:49
An: firebird-support@yahoogroups.com
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:firebird-support@yahoogroups.com

Sent: Thursday, February 19, 2015 12:40 PM

To: firebird-support@yahoogroups.com
<mailto:firebird-support@yahoogroups.com>

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

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





[Non-text portions of this message have been removed]



------------------------------------
Posted by: "Parzival" <parzival1969@...>
------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu
there.

Also search the knowledgebases at
http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links