Re: odbc>=8.1 and the broken euro symbol

From: R. Schierbeek <bytelifeNospam_at_gmail.com>
Date: Fri, 16 Sep 2005 20:32:31 +0200
Message-ID: <432b0077$0$94519$dbd4f001@news.wanadoo.nl>

hello Jan,

Check your NLS_CHARACTERSET - it should be something like WE8ISO8859P15 for
the euro to be correctly saved in the database.

Also NLS_LANG on the server / windows should be .WE8ISO8859P15 or your translation could be lost on the way to wherever you're coming from.

Cheers roelof

"jan rosinowski" <spamfilter_at_rsp.de> schreef
> hi,
> i need to retrieve the euro-character from a database but
>
> select 'µäöüß?' f from dual
>
> returns
> 'µäöüß?' (or sometimes a turned questionmark)
>
> the oracle odbc-driver translation option is set to 0 which is the
> default.
> what's going on here?
Received on Fri Sep 16 2005 - 13:32:31 CDT