Default Character Set for Oracle 10g install

Posted on 2007-10-19
Last Modified: 2013-12-19
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??


Question by:chumplet
    LVL 18

    Expert Comment

    I think the character set would be AL16UTF16

    You could also check using this query

    select * from nls_database_parameters;
    LVL 18

    Assisted Solution

    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.
    LVL 27

    Assisted Solution

    >> "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.
    LVL 47

    Accepted Solution

    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
    WHERE parameter= 'NLS_CHARACTERSET';

    SELECT value FROM nls_database_parameters

    The most universal character set is AL32UTF8 - 4 bytes Unicode.
    LVL 6

    Author Comment

    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!


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Suggested Solutions

    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now