4 Replies Latest reply: Oct 4, 2012 2:37 AM by orafad RSS

    what is unicode character set?

    yash_08031983
      Hello experts, i am using oracle 10g
      with character set info:
      SQL> select * from NLS_DATABASE_PARAMETERS;
      
      PARAMETER                      VALUE
      ------------------------------ ----------------------------------------
      NLS_LANGUAGE                   AMERICAN
      NLS_TERRITORY                  AMERICA
      NLS_CURRENCY                   $
      NLS_ISO_CURRENCY               AMERICA
      NLS_NUMERIC_CHARACTERS         .,
      NLS_CHARACTERSET               WE8MSWIN1252
      NLS_CALENDAR                   GREGORIAN
      NLS_DATE_FORMAT                DD-MON-RR
      NLS_DATE_LANGUAGE              AMERICAN
      NLS_SORT                       BINARY
      NLS_TIME_FORMAT                HH.MI.SSXFF AM
      
      PARAMETER                      VALUE
      ------------------------------ ----------------------------------------
      NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
      NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
      NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
      NLS_DUAL_CURRENCY              $
      NLS_COMP                       BINARY
      NLS_LENGTH_SEMANTICS           BYTE
      NLS_NCHAR_CONV_EXCP            FALSE
      NLS_NCHAR_CHARACTERSET         AL16UTF16
      NLS_RDBMS_VERSION              10.2.0.1.0
      
      20 rows selected.
      
      SQL> 
      i install and configure cognos.. while test for contant manager connection test: error is given
      as:
      Content Manager cannot start because the content store database character set is not supported.

      so i have to change character set to unicode.

      so please tell me how to change so that data don't loss .

      thanks
      yash