Re: CHARACTER SET problem

You should also re-create any indexes that may contain non-standard characters (i.e. French accents). This will ensure that the values are in the correct order.

Hakan wrote in message <35F51686.523B401B_at_ibm.net>...
>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