Re: charset problem with '¤' ?

Sam wrote:
> 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
>

SQL*Plus from the commandline or the graphical version, other tool?

If you're on the commandline it might help to issue chcp 1252 before invoking sqlplus and setting the font to Lucida Console.

HTH
Holger Received on Tue Aug 30 2005 - 04:19:21 CDT