Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 17019
  • Last Modified:

Default Character Set for Oracle 10g install

We have a client asking us about the "default character set" for an Oracle 10g install.  I'm having trouble finding that information.  Is it WE8ISO8859P1, by chance?  If not, what is it??


3 Solutions
I think the character set would be AL16UTF16

You could also check using this query

select * from nls_database_parameters;
few lines from metalink...

Starting in Oracle 9i the National Characterset (NLS_NCHAR_CHARACTERSET) will be
limited to UTF8 and AL16UTF16.

For more details refer to  The National Character Set in Oracle 9i and 10g

Any other NLS_NCHAR_CHARACTERSET will no longer be supported.
When upgrading to 10g the value of NLS_NCHAR_CHARACTERSET is based
on value currently used in the Oracle8 version.

If the NLS_NCHAR_CHARACTERSET is UTF8 then new it will stay UTF8.
In all other cases the NLS_NCHAR_CHARACTERSET is changed to AL16UTF16
and -if used- N-type data (= data in columns using NCHAR, NVARCHAR2 orNCLOB )
may need to be converted.
>> "default character set" for an Oracle 10g install

Character Set is the property of a database. It is not the property of the installation. When you create a database, you "have" to specify the character set. There is no default.
sujith80 gave you correct answer.
When creating a DB (using DBCA utility ot by initial install of the Oracle Software)
Oracle tries using local settings of the machine to determine which character set
is the most appropriate for this installation ... and the decission very often is wrong.
Because of the globalization of the world.
When I create a DB in Germany Oracle decides to use West European Characte set,
but the company needs Unicode (AL32UTF8) Character set.

So never accept without checking and consideration the
Character set proposed by Oracle!

To check which is the character set of the DB use;

SELECT value FROM nls_database_parameters

SELECT value FROM nls_database_parameters

The most universal character set is AL32UTF8 - 4 bytes Unicode.
chumpletAuthor Commented:
Thanks, all.  I awarded the majority of the points to Schwertner because that response was the most thorough and eventually helped us find what we needed.

Thanks again!


Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now