首页 » ORACLE » How to choose “non recommended” character sets(US7ASCII、WE8ISO8859P1) in DBCA 11G, 12C or later

How to choose “non recommended” character sets(US7ASCII、WE8ISO8859P1) in DBCA 11G, 12C or later

We limit the default display of database character sets that can be used for a new database in Oracle Database 11 via DBCA (Database Creation Assistant) based on the recommended list.

In the release 11gR1 and later of the Oracle database, we reduce the number of character sets on offer trough the DBCA (Database Creation Assistant) to customers to a list of recommended charactersets.
If it is required to create a database using one of the “non recommended” character sets in the 11g DBCA (US7ASCII or WE8ISO8859P1 for example) start the 11g DBCA and in step 9 of 11 of the DBCA choose the “Character Sets” tab, under “Database Character Set” header select the “Choose from the list of character sets” button and deselect the “show recommended character sets only” box .

In the 12c the location of choosing an “non recommended” character set is somewhat changed:
Start the 12c DBCA ,  choose ” create a database” , in step 2 choose the “advanced mode” and in step 10 of 14 of the 12c DBCA go to the the “Character Sets” tab, select the “Choose from the list of character sets” button and deselect the “show recommended character sets only” box . An “non recommended” characterset (US7ASCII or WE8ISO8859P1 for example) can then be used as Database Character Set (NLS_CHARACTERSET).

Note that ALL character sets are still SUPPORTED and “non recommended” character sets can be used if needed.

As mentioned above the CREATE DATABASE COMMAND still allows legacy, non-recommended character sets. This is unless and until any given character set is placed on our obsolete/deprecated list. Note the change the default behavior in Oracle Database 11g when customers don’t specify the character set for the CREATE DATABASE COMMAND. The default is changed from US7ASCII to AL32UTF8.

To know what characters are known in a certain characterset then please see Note 282336.1 Charts of most current mono-byte Character sets

Japanese, Korean and Chinese character sets

JA16SJIS
JA16SJISTILDE
JA16EUC
JA16EUCTILDE
KO16MSWIN949
ZHS16GBK
ZHT16MSWIN950
ZHT16HKSCS
ZHT16HKSCS31
ZHT32EUC

Comments on some popular database character sets that are not recommended

US7ASCII: better to migrate to WE8MSWIN1252, or WE8ISO8859P15 etc.
WE8ISO8859P1: WE8MSWIN1252 is a superset
UTF8: better to migrate to AL32UTF8
ZHS16CGB231280: ZHS16GBK is a superset
KO16KSC5601: KO16MSWIN949 is a superset
ZHT16BIG5: ZHT16MSWIN950 solves various problems of ZHT16BIG5

References ORACLE Docs.

打赏

,

对不起,这篇文章暂时关闭评论。