Oracle 9i CHARACTERSET
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle 9i CHARACTERSET

Hybrid View

  1. #1
    Join Date
    Jul 2001
    Posts
    108

    Oracle 9i CHARACTERSET

    Hello,

    We have installed the Oracle 9i database (fresh installation) using the CHARACTERSET WE8ISO8859P1.

    Later on we figured it out that we need the CHARACTERSET WE8MSWIN1252 and with UNI-CODE enabled.

    What I have done is:

    I have started the database in a restricted mode.
    then I issued the following command:
    alter database character set WE8MSWIN1252;

    select * from NLS_DATABASE_PARAMETERS;

    NLS_CHARACTERSET WE8MSWIN1252
    NLS_NCHAR_CHARACTERSET AL16UTF16


    and much more lines.

    Now, what should I do in order to set the database to UNI-CODE?

    Thank you,
    Nikee
    -Nikee

  2. #2
    Join Date
    Nov 2005
    Location
    USA
    Posts
    32
    Hi Nikee,

    WE8MSWIN1252 is not UNICODE characterset.
    You may need to choose from the following if you want unicode cs.

    UTF8,UTFE,AL32UTF8,AL16UTF16.

    I dont think there is any dict. view available to check if unicode is supported. You should derive it by charactersets.

    Thks,
    Sunil

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width