Re: odbc>=8.1 and the broken euro symbol

hello Jan,

You 'll never get any result from sqlplus; as it doesn't support the euro - nor umlaut and characters like that. So spooling it to a text file and opening with Word is the only way to do it.
You can set NLS_LANFG on the OS/ or client level:

    NLS_LANG=AMERICAN.WE8ISO8859P1 since your db setting is NLS_CHARACTERSET=WE8ISO8859P1

    good luck, Roelof

"jan rosinowski" <spamfilter_at_rsp.de> schreef
> some additional observation which makes it completely bizarre:
>
> i store queries in my db and execute them. the following sample
> queries its own code and appends some text. if i execute it i get this
> result from sqlplus:
>
> select aenderungsabfrage || '@µäöüß?' from t_attributtypen where
> attributtypcode like 'EURO%'@µäöüß¿
>
> euro-sign is shown as small box but when copied into a native windows
> apps it gets shown as a eurosymbol
>
> so plain text seems to be retrieved fine but any "calculation" like
> appending a literal messes things up
Received on Sat Sep 17 2005 - 05:51:01 CDT