0 Replies Latest reply on Dec 11, 2015 10:47 AM by Nellai Natarajan

    Oracle Apex Restful Web Service character encoding.

    Nellai Natarajan

      Hi there,

       

      Apex Version: 4.2.2.00.11

      CGI Environment

      APEX_LISTENER_VERSION2.0.2.133.14.47
      PLSQL_GATEWAYWebDb
      GATEWAY_IVERSION3
      SERVER_SOFTWAREMod-Apex
      GATEWAY_INTERFACECGI/1.1
      REQUEST_METHODGET
      PATH_INFO/f
      REMOTE_ADDR0:0:0:0:0:0:0:1
      SERVER_PROTOCOLHTTP/1.0
      REQUEST_PROTOCOLhttp
      HTTP_USER_AGENTMozilla/5.0 (Windows NT 6.1; WOW64; rv:42.0) Gecko/20100101 Firefox/42.0
      HTTP_ACCEPT_ENCODINGgzip, deflate
      HTTP_ACCEPT_LANGUAGEen-US,en;q=0.5
      HTTP_ORACLE_ECID
      WEB_AUTHENT_PREFIX
      DAD_NAME
      DOC_ACCESS_PATH
      DOCUMENT_TABLE
      PATH_ALIAS
      REQUEST_CHARSETAL32UTF8
      REQUEST_IANA_CHARSETUTF-8
      SCRIPT_PREFIX

       

      Database version

       

      • CORE 11.2.0.3.0 Production  
      • NLSRTL Version 11.2.0.3.0 - Production  
      • Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production  
      • PL/SQL Release 11.2.0.3.0 - Production  
      • TNS for Linux: Version 11.2.0.3.0 - Production  

       

      Character Set

       

      NLS_CHARACTERSET:AL32UTF8
      DAD CHARACTERSET:UTF-8
      JOB_QUEUE_PROCESSES:10

       

      Running in Glassfish Environment

       

      Scneario: We are rendering a web serivice using Apex Restful Web Service so that the consumer consumes the data in CSV format. By default the data is encoded in UTF-8 format.

       

      Issue: However the consumer system requires the data to be in UTF-8 WITH BOM (Bytes of Mark) encoding since it couldn't receive the umlaut charcaters correctly with the UTF-8 encoding. I couldn't find any option to instruct the process to the use the specified encoding. Is there an option to change it?

       

      Advance thanks.

       

      Regards,

       

      Natarajan