1 Reply Latest reply: Aug 2, 2013 9:52 AM by Neeraj Singh RSS

    Data store in multilangual

    2c4fcb5c-77eb-48a5-b2e6-a8b9c578f560

      Hi All !

             My NLS_DATABASE_PARAMETERS is posted below. I want to know that for a particular table how cane we insert the value in column with different language with NVARCHAR2 datatype and also fetch the data same.Is there any option to do it without change the value of NLS_CHARACTERSET to 'UTF-8', if so then kindly tell me the process. Thx in advance.

      av@delhi>select * From NLS_DATABASE_PARAMETERS

        2  ;

      more........

      PARAMETER                      VALUE

      ------------------------------ ----------------------------------------

      NLS_LANGUAGE                   AMERICAN

      NLS_NCHAR_CHARACTERSET         AL16UTF16

      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

      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_RDBMS_VERSION              11.1.0.6.0