1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Changing value WE8MSWIN1252 to UTF-8

Discussion in 'General' started by tims_oracle, Jul 14, 2010.

  1. tims_oracle

    tims_oracle Guest

    Hi,

    I have installed oracle 9i and I fired the below query

    SELECT parameter, value FROM nls_database_parameters
    WHERE parameter = 'NLS_CHARACTERSET';

    parameter value
    NLS_CHARACTERSET WE8MSWIN1252


    Now I want to change the value to UTF-8

    Could you pls let me know how I can achieve this because one of my reoprting application needs UTF-8.

    Is this (WE8MSWIN1252) value same as UTF-8???

    Pls guide me as I am new to Oracle.

    Thanks,
     
  2. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India