Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: odbc>=8.1 and the broken euro symbol

Re: odbc>=8.1 and the broken euro symbol

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 16 Sep 2005 21:19:34 +0200
Message-ID: <dgf5dd$tt1$3@news2.zwoll1.ov.home.nl>


jan rosinowski wrote:
> 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?

NLS_LANG issue - what is your value?
WE8ISO8859P1 is *not* going to work, WE8MSWIN1252 is your best shot.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Fri Sep 16 2005 - 14:19:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US