Re: NLS PARAMETERS

RMM wrote:
>
> Hello
>
> I have a problem with french accent that are displayed wrong. I have
> check in the table V$NLS_PARAMETERS here is what I've got :
>
> PARAMETER VALUE
>
> ---------------------------------------------------------------- --------
> --------------------------------------------------------
> NLS_LANGUAGE FRENCH
>
> NLS_TERRITORY FRANCE
>
> NLS_CURRENCY F
>
> NLS_ISO_CURRENCY FRANCE
>
> NLS_NUMERIC_CHARACTERS ,.
>
> NLS_CALENDAR
> GREGORIAN
> NLS_DATE_FORMAT DD/MM/YY
>
> NLS_DATE_LANGUAGE FRENCH
>
> NLS_CHARACTERSET US7ASCII
>
> NLS_SORT FRENCH
>
> NLS_TIME_FORMAT
> HH24:MI:SSXFF
> NLS_TIMESTAMP_FORMAT DD/MM/YY
> HH24:MI:SSXFF
> NLS_TIME_TZ_FORMAT
> HH24:MI:SSXFF TZH:TZM
> NLS_TIMESTAMP_TZ_FORMAT DD/MM/YY
> HH24:MI:SSXFF TZH:TZM
> NLS_DUAL_CURRENCY ?
>
> NLS_NCHAR_CHARACTERSET US7ASCII
>
> NLS_COMP
>
> It seems that the NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET is wrong
> for french. How can I change that ? I've read on the Oracle website that
> is kind of risky for changing that...
>
> Thanks for the help
>
> Olivier

What I remember is that the character sets are specified as a clause of the CREATE DATABASE statement. The character set for a database can not be changed after you issue the CREATE DATABASE statement, because everything is stored in the characterset specified there. The default is typically US7ASCII which is what your NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET are set to.

--
Hogarth

Please remove **nospam** from email address to reply Received on Mon Oct 18 1999 - 09:57:28 CDT