Re: changing character set in oracle

STOP!!! You cannot change the character-set in Oracle 8.0.x by updating sys.props$ !!! If you try, you will get various ORA-600 errors when opening the database.

In fact you cannot change the chararacter-set on 8.0.x in any way.

In Oracle7 you could use the (unsupported) method of updating sys.props$

In Oracle8i you can:
ALTER DATABASE SET [NATIONAL] CHARACTER_SET=... (not 100% sure about the syntax - don't have my manuals near me).

Cheers,
Gollum

On Wed, 09 Feb 2000 16:38:38 GMT, Hakan Eren <heren_at_home.com> wrote:

>Hi,
>
>I just replied for the same question:
>
>Hi,
>
>You can change the character set without re-installing the database.
>First you need to have a verified backup! Also I recommend you to read
>Oracle Server Reference Manual/National Language Support.
>
>My Oracle Database version 7.3.4 has the following character sets:
>
>US7ASCII ASCII 7-bit American
> WE8DEC DEC 8-bit West European
> WE8HP HP LaserJet 8-bit West European
> US8PC437 IBM-PC Code Page 437 8-bit American
> WE8EBCDIC37 EBCDIC Code Page 37 8-bit West
>European
> WE8EBCDIC500 EBCDIC Code Page 500 8-bit West
>European
> WE8PC850 IBM-PC Code Page 850 8-bit West European
> D7DEC DEC VT 100 7-bit German
> F7DEC DEC VT 100 7-bit French
> S7DEC DEC VT100 7-bit Swedish
> E7DEC DEC VT100 7-bit Spanish
> SF7ASCII ASCII 7-bit Finnish
> NDK7DEC DEC VT100 7-bit Norwegian/Danish
> I7DEC DEC VT100 7-bit Italian
> NL7DEC DEC VT100 7-bit Dutch
> CH7DEC DEC VT100 7-bit Swiss (German/French)
> YUG7ASCII ASCII 7-bit Yugoslavian
> SF7DEC DEC VT 100 7-bit Finnish
> TR7DEC DEC VT100 7-bit Turkish
> WE8ISO8859P1 ISO 8859-1 West European
> EE8ISO8859P2 ISO 8859-2 East European
> SE8ISO8859P3 ISO 8859-3 South European
> NEE8ISO8859P4 ISO 8859-4 North and North-East
>European
> CL8ISO8859P5 ISO 8859-5 Latin/Cyrillic
> AR8ISO8859P6 ISO 8859-6 Latin/Arabic
> EL8ISO8859P7 ISO 8859-7 Latin/Greek
> IW8ISO8859P8 ISO 8859-8 Latin/Hebrew
> WE8ISO8859P9 ISO 8859-9 West European & Turkish
> NE8ISO8859P10 ISO 8859-10 North European
> TH8TISASCII Thai Industrial Standard 620-2533 -
>ASCII 8-bit
> TH8TISEBCDIC Thai Industrial Standard 620-2533 -
>EBCDIC 8-bit
> AR8EBCDICX EBCDIC XBASIC 8-bit Latin/Arabic
> EL8DEC DEC 8-bit Latin/Greek
> TR8DEC DEC 8-bit Turkish
> WE8EBCDIC37C EBCDIC Code Page 37 8-bit Oracle/c
> RU8PC866 IBM-PC Code Page 866 8-bit Latin/Cyrillic
> WE8EBCDIC500C EBCDIC Code Page 500 8-bit Oracle/c
> EEC8EUROPA3 EEC EUROPA3 8-bit West European/Greek
> EE8PC852 IBM-PC Code Page 852 8-bit East European
> RU8BESTA BESTA 8-bit Latin/Cyrillic
> RU8PC855 IBM-PC Code Page 855 8-bit Latin/Cyrillic
> TR8PC857 IBM-PC Code Page 857 8-bit Turkish
> CL8MACCYRILLIC Mac Client 8-bit Latin/Cyrillic
> CL8MACCYRILLICS Mac Server 8-bit Latin/Cyrillic
> WE8PC860 IBM-PC Code Page 860 8-bit West European
> IS8PC861 IBM-PC Code Page 861 8-bit Icelandic
> EE8MACCES Mac Server 8-bit Central European
> EE8MACCROATIANS Mac Server 8-bit Croatian
> TR8MACTURKISHS Mac Server 8-bit Turkish
> IS 8MACICELANDICS Mac Server 8-bit Icelandic
> EL8MACGREEKS Mac Server 8-bit Greek
> EE8MSWIN 1250 MS Windows Code Page 1250 8-bit East
>European
> CL8MSWIN1251 MS Windows Code Page 1251 8-bit
>Latin/Cyrillic
> F8EBCDIC297 EBCDIC Code Page 297 8-bit French
> BG8MSWIN MS Windows 8-bit Bulgarian Cyrillic
> EL8MSWIN1253 MS Windows Code Page 1253 8-bit
>Latin/Greek
> D8EBCDIC273 EBCDIC Code Page 273/18-bit Austrian
>German
> I8EBCDIC280 EBCDIC Code Page 280/18-bit Italian
> DK8EBCDIC277 EBCDIC Code Page 277/18-bit Danish
> S8EBCDIC278 EBCDIC Code Page 278/18-bit Swedish
> EE8EBCDIC870 EBCDIC Code Page 870 8-bit East
>European
> CL8EBCDIC1025 EBCDIC Code Page 1025 8-bit Cyrillic
> N8PC865 IBM-PC Code Page 865 8-bit Norwegian
> F7SIEMENS9780X Siemens 97801/97808 7-bit French
> E7SIEMENS9780X Siemens 97801/97808 7-bit Spanish
> S7SIEMENS9780X Siemens 97801/97808 7-bit Swedish
> DK7SIEMENS9780X Siemens 97801/97808 7-bit Danish
> N7SIEMENS9780X Siemens 97801/97808 7-bit Norwegian
> I7SIEMENS9780X Siemens 97801/97808 7-bit Italian
> D7SIEMENS9780X Siemens 97801/97808 7-bit German
> WE8GCOS7 Bull EBCDIC GCOS7 8-bit West European
> US8BS2000 Siemens 9750-62 EBCDIC 8-bit American
> D8BS2000 Siemens 9750-62 EBCDIC 8-bit German
> F8BS2000 Siemens 9750-62 EBCDIC 8-bit French
> E8BS2000 Siemens 9750-62 EBCDIC 8-bit Spanish
> DK8BS2000 Siemens 9750-62 EBCDIC 8-bit Danish
> WE8BS2000 Siemens EBCDIC.DF.04 8-bit West European
> CL8BS2000 Siemens EBCDIC.EHC.LC 8-bit Cyrillic
> WE8BS2000L5 Siemens EBCDIC.DF.O4.L5 8-bit West
>European/Turkish
> WE8DG DG 8-bit West European
> WE8NCR4970 NCR 4970 8-bit West European
> WE8ROMAN8 HP Roman8 8-bit West European
> EE8MACCE Mac Client 8-bit Central European
> EE8MACCROATIAN Mac Client 8-bit Croatian
> TR8MACTURKISH Mac Client 8-bit Turkish
> IS8MACICELANDIC Mac Client 8-bit Icelandic
> EL8MACGREEK Mac Client 8-bit Greek
> US8ICL ICL EBCDIC 8-bit American
> WE8ICL ICL EBCDIC 8-bit West European
> WE8MACROMAN8 Mac Client 8-bit Extended Roman8 West
>European
> WE8MACROMAN8S Mac Server 8-bit Extended Roman8
>West European
> TH8MACTHAI Mac Client 8-bit Latin/Thai
> TH8MACTHAIS Mac Server 8-bit Latin/Thai
> HU8CWI2 Hungarian 8-bit CWI-2
> TR8ISO8859P9 Turkish version ISO 8859-9 West
>European & Turkish
> EL8PC437S IBM-PC Code Page 437 8-bit (Greek
>modification)
> EL8EBCDIC875 EBCDIC Code Page 875 8-bit Greek
> EL8PC737 IBM-PC Code Page 737 8-bit Greek/Latin
> LT8PC772 IBM-PC Code Page 772 8-bit Lithuanian
>(Latin/Cyrillic)
> LT8PC774 IBM-PCCode Page 774 8-bit Lithuanian
>(Latin)
> CDN8PC863 IBM-PC Code Page 863 8-bit Canadian
>French
> AR8ASMO8X ASMO Extended 708 8-bit Latin/Arabic
> AR8NAFITHA711 Nafitha Enhanced 711 Server 8-bit
>Latin/Arabic
> AR8SAKHR707 SAKHR 707 Server 8-bit Latin/Arabic
> AR8MUSSAD768 Mussa'd Alarabi/2 768 Server 8-bit
>Latin/Arabic
> AR8ADOS710 Arabic MS-DOS 710 Server 8-bit
>Latin/Arabic
> AR8ADOS720 Arabic MS-DOS 720 Server 8-bit
>Latin/Arabic
> AR8APTEC715 APTEC 715 Server 8-bit Latin/Arabic
> AR8MSWIN1256 MS Windows Code Page 1256 8-Bit
>Latin/Arabic
> AR8NAFITHA721 Nafitha International 721 Server
>8-bit Latin/Arabic
> AR8SAKHR706 SAKHR 706 Server 8-bit Latin/Arabic
> AR8ARABICMAC Mac Client 8-bit Latin/Arabic
> AR8ARABICMACS Mac Server 8-bit Latin/Arabic
> JA16VMS JVMS 16-bit Japanese
> JA16EUC EUC 16-bit Japanese
> JA16SJIS Shift-JIS 16-bit Japanese
> JA16DBCS IBM DBCS 16-bit Japanese
> JA16HP HP 16-bit Japanese
> JA16EBCDIC930 IBM DBCS Code Page 290 16-bit
>Japanese
> JA16TOSHIBAEUC Toshiba EUC 16-bit Japanese
> KO16KSC5601 KSC5601 16-bit Korean
> KO16DBCS IBM DBCS 16-bit Korean
> ZHS16CGB231280 CGB2312-80 16-bit Simplified Chinese
> ZHT32EUC EUC 32-bit Traditional Chinese
> ZHT32SOPS SOPS 32-bit Traditional Chinese
> ZHT16DBT Taiwan Taxation 16-bit Traditional
>Chinese
> ZHT32TRIS TRIS 32-bit Traditional Chinese
> ZHT16BIG5 BIG5 16-bit Traditional Chinese
> AL24UTFFSS Unicode UTF-FSS
> JA16TSTSET2 ASCII-based 16-bit Test Character Set
> JA16TSTSET Shift-sensitive ASCII-based Test
>Character Set
>
>As you see there is no Danish/Icelandic. Anyway, let's say you want to
>change it
>to a certain character set, for example NE8ISO8859P10 ISO 8859-10 North
>European
>
>Then please do the following in SQLPlus as user SYS:
>
>SELECT * FROM V$NLS_PARAMETERS
>/
>(This will show you your language settings)
>
>UPDATE sys.props$
> SET value$ = 'NE8ISO8859P10'
> WHERE name = 'NLS_CHARACTERSET'
>/
>COMMIT
>/
>
>Then set the environment variables:
>
>(The NLS_LANG environment variable has three components (language,
>territory, and charset) in the form:
>NLS_LANG = language_territory.charset)
>
>If it is UNIX, please check the following environmental variables:
>
>NLS_LANG = ICELANDIC_DENMARK.NE8ISO8859P10
>ORA_NLS = $ORACLE_HOME/ocommon/nls/admin/data
>ORA_NLS32 = $ORACLE_HOME/ocommon/nls/admin/data
>
>If it is NT they are registry values. You need to edit windows registry.
>
>Then just re-start the database.
>
>Hakan
>
>Note: Please look at all NLS parameters and
> determine the values before you proceed.
>
>Steve Ball wrote:
>>
>> All,
>>
>> Is it true that it is not possible to alter a database's character set
>> without re-installing the database?
>>
>> I would like to change the character set of my database from Turkish to
>> Danish/Icelandic.
>>
>> Any help appreciated... else, db exp/imp it is!
>>
>> Steve
>
>
>maylee wrote:
>>
>> I wanted to know if I can change the ASCII7 character set on an
>> existing database to 8bit ascii character set without recreating the
>> database. I'm running 8.0.5 on solaris...
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
Received on Wed Feb 09 2000 - 16:09:53 CST