0 Replies Latest reply: May 28, 2014 2:15 AM by Abdul Jabbar RSS

    Unable to show Unicode Data in Oracle RESTful Service JSON

    Abdul Jabbar

      Hi Everyone.

       

      I have stored unicode data in Oracle database and when i retrieve in sql query it is showing the same. But when i retrieve the data in json using oracle RESTful web service (GET), it bringing with unknown character as shown below.

       

      {

      }


      My Database Setup as below:


      SQL> SELECT name,value$ FROM sys.props$;

       

       

      NAME                                                          VALUE$

      DICT.BASE                                                  2

      DEFAULT_TEMP_TABLESPACE               TEMP

      DEFAULT_PERMANENT_TABLESPACE     USERS

      DEFAULT_EDITION                                   ORA$BASE

      Flashback Timestamp TimeZone                    GMT

      TDE_MASTER_KEY_ID

      DBTIMEZONE                                        -07:00

      DST_UPGRADE_STATE                         NONE

      DST_PRIMARY_TT_VERSION               11

      DST_SECONDARY_TT_VERSION          0

      DEFAULT_TBS_TYPE                              SMALLFILE

      NLS_LANGUAGE                              AMERICAN

      NLS_TERRITORY                                   AMERICA

      NLS_CURRENCY                                   $

      NLS_ISO_CURRENCY                         AMERICA

      NLS_NUMERIC_CHARACTERS               .,

      NLS_CHARACTERSET                         AL32UTF8

      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_NCHAR_CHARACTERSET          AL16UTF16

      NLS_RDBMS_VERSION               11.2.0.1.0

      GLOBAL_DB_NAME                    MOBILE

      EXPORT_VIEWS_VERSION   

       

       

      SQL> select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET',

        2  'NLS_LANGUAGE', 'LANGUAGE',

        3  'NLS_TERRITORY', 'TERRITORY') name,

        4  value from v$nls_parameters

        5  WHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY');

       

       

      NAME          VALUE

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

      LANGUAGE      AMERICAN

      TERRITORY     AMERICA

      CHARACTER SET AL32UTF8

                8

      WORKLOAD_CAPTURE_MODE    

      WORKLOAD_REPLAY_MODE

       

      Awaiting you solution.

       

      -- Abdul Jabbar