Re: CHARACTER SET problem

On Tue, 8 Sep 1998 10:57:20 -0400, Al <al_at_work> wrote:
>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.

Won't this be unnecessary unless NLS_SORT is set?

>
>
>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
>>
>
>

-- 
These opinions are my own and not necessarily those of Information Quest or 
Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com
http://ourworld.compuserve.com/homepages/joel_garry   Remove nospam to reply.  
mailto:joel_garry_at_compuserve.nospam.com  "See your DBA?"  I AM the @#%*& DBA!