| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Changing the language set of the database
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 TestCharacter 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
Received on Wed Feb 09 2000 - 10:32:08 CST
 |
 |