charset problem with '¤' ?

From: Sam <s_becker_at_voila.fr>
Date: 30 Aug 2005 02:05:34 -0700
Message-ID: <1125392734.183017.94220@g43g2000cwa.googlegroups.com>

Hello

I have a problem which looks like a problem of charset with my Oracle 9.2 instance.

I perform a select '¤' from dual and it gives me '¿'.

Here's the result of a select * from nls_database_parameters:

PARAMETER                      VALUE


------------------------------ ---------------------------------

NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               WE8ISO8859P15
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM

PARAMETER                      VALUE


------------------------------ ---------------------------------

NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              $
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_RDBMS_VERSION              9.2.0.6.0

In the windows registry, nls_lang is set to FRENCH_FRANCE.WE8MSWIN1252... Any idea ?
Thanks,
Samuel Received on Tue Aug 30 2005 - 04:05:34 CDT