Re: Changing character set

Hello Noreen,

You can see database parameters in sys.props$:

>select * from sys.props$

NAME                           VALUE$
------------------------------ ---------------
DICT.BASE                      2
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_DATE_FORMAT                DD-MON-YY
NLS_DATE_LANGUAGE              AMERICAN
NLS_CHARACTERSET               RU8PC866     <-- You can update this value!
NLS_SORT                       BINARY
NLS_CALENDAR                   GREGORIAN
NLS_RDBMS_VERSION              7.2.2.4.0
GLOBAL_DB_NAME                 ORACLE.WORLD

But you should be very cearefull and set correct value. If you set error value then database will not startup.

>
> We are planning to change the character set on our databases from
> US7ASCII to WE8ISO8859P1 to allow us to store French,German,etc.
> language characters. We don't actually need to change the language.
> Has anybody done anything like this and if so do you have any advice
> to offer.
>
> We are using the following versions of Oracle :
> 7.1.3, 7.1.6 and 7.2
>
>
> Thanks in advance,
>
> Noreen Murray.
>
Received on Fri Mar 07 1997 - 00:00:00 CST