Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CHARACTER SET problem
Hi,
Actually you don't need to create export/create a new database. However
you
should be very careful.
You can update database character set settings to WE8ISO8859P1 in the
SYS.PROPS$ table.
To change the Oracle RDBMS to an 8-bit (WE8ISO8859P1) database, you must
enter the following command in SQL*Plus as the SYS user:
(or in server manager whereever you like)
UPDATE SYS.PROPS$
SET value$ = 'WE8ISO8859P1'
WHERE name = 'NLS_CHARACTERSET’ ;
COMMIT ;
Before starting the database instance, if you have a UNIX env. be sure
the
following UNIX environmental variables are set:
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1 ORA_NLS = $ORACLE_HOME/ocommon/nls/admin/data ORA_NLS32 = $ORACLE_HOME/ocommon/nls/admin/data
If you have NT update registry accordingly.
Don't forget to back up your system before you begin any character set
changes,
If you like to view the NLS parameter settings, enter the following
command:
"SELECT * from V$NLS_PARAMETERS "
Please be sure the value$ you enter is correct. Whatever you typed will
be
accepted.
You may be able to shut down the database but cannot start the database!
Regards
Hakan Eren
NVC Inc.
Frank Zekert wrote:
> Hi !
> just forgot your second point:
>
> 1 Export your database
> 2 re-create database with correct character set
> 3 import from the file created by (1). Fortunately US7ASCII maps
> seamlessly into WE8ISO8859P1,
> the other way round is to be expected much more difficult ;-)
>
> Frank
>
> dvsingh1_at_my-dejanews.com schrieb in Nachricht
> <6t2e6o$6b5$1_at_nnrp1.dejanews.com>...
> >Hi...
> >
> >I have a critical problem with the character set . I created a
> >database with the character set 'US7ASCII' . Now I need to insert the
> >data from European character set
> >'WE8ISO8859P1' .
> > Should I need to recreate the database to insert
> >european characters ? . Is there any alternative method to change the
> >character set ? Please Advice.....
> >
> >Also advice on porting an 7 bit database ( e.g US7ASCII ) to an 8 bit
> >database. Thanks .. Digendra Vir Singh dvsingh_at_amsoftindia.co.in
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Sep 08 1998 - 00:00:00 CDT