3 Replies Latest reply on Jul 26, 2019 10:16 AM by fac586

    Display an NVARCHAR2 data in Apex 4.2

    LT.ora

      I'm not able to display NVARCHAR2 data in Apex 4.2 the data is visible in database

      Untitled.png

        • 1. Re: Display an NVARCHAR2 data in Apex 4.2
          fac586

          LT.ora wrote:

           

          I'm not able to display NVARCHAR2 data in Apex 4.2 the data is visible in database

          Untitled.png

          Please provide the following information (as text, not screenshots):

           

          • Full details of your environment (most of this information can be found in the "About Application Express" dialog (? > About on the App Builder toolbar)
          • The results of executing select * from nls_database_parameters in SQL Workshop
          • The values of the following application globalization attributes:
            • Application Primary Language
            • Application Language Derived From
          • The browser language settings
          • 2. Re: Display an NVARCHAR2 data in Apex 4.2
            LT.ora
            • The results of executing select * from nls_database_parameters in SQL Workshop

            NLS_RDBMS_VERSION    12.1.0.1.0

            NLS_NCHAR_CONV_EXCP    FALSE

            NLS_LENGTH_SEMANTICS    BYTE

            NLS_COMP    BINARY

            NLS_DUAL_CURRENCY    $

            NLS_TIMESTAMP_TZ_FORMAT    DD-MON-RR HH.MI.SSXFF AM TZR

            NLS_TIME_TZ_FORMAT    HH.MI.SSXFF AM TZR

            NLS_TIMESTAMP_FORMAT    DD-MON-RR HH.MI.SSXFF AM

            NLS_TIME_FORMAT    HH.MI.SSXFF AM

            NLS_SORT    BINARY

            NLS_DATE_LANGUAGE    AMERICAN

            NLS_DATE_FORMAT    DD-MON-RR

            NLS_CALENDAR    GREGORIAN

            NLS_NUMERIC_CHARACTERS    .,

            NLS_NCHAR_CHARACTERSET    AL16UTF16

            NLS_CHARACTERSET    WE8MSWIN1252

            NLS_ISO_CURRENCY    AMERICA

            NLS_CURRENCY    $

            NLS_TERRITORY    AMERICA

            NLS_LANGUAGE    AMERICAN

             

             

            CGI Environment

            APEX_LISTENER_VERSION
            PLSQL_GATEWAYWebDb
            GATEWAY_IVERSION2
            SERVER_SOFTWAREOracle Embedded PL/SQL Gateway/12.1.0.1.0
            GATEWAY_INTERFACECGI/1.1
            SERVER_PORT8080
            SERVER_NAMEXDB HTTP Server
            REQUEST_METHODGET
            QUERY_STRINGp=4350:9:7556185269562::NO:::
            PATH_INFO/f
            SCRIPT_NAME/apex
            REMOTE_ADDR172.168.2.100
            SERVER_PROTOCOLHTTP/1.1
            REQUEST_PROTOCOLHTTP
            REMOTE_USERANONYMOUS
            HTTP_USER_AGENTMozilla/5.0 (Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0
            HTTP_HOST172.168.1.60:8080
            HTTP_ACCEPT_ENCODINGgzip,deflate
            HTTP_ACCEPT_LANGUAGEen-US,en;q=0.5
            HTTP_ORACLE_ECID
            WEB_AUTHENT_PREFIX
            DAD_NAMEapex
            DOC_ACCESS_PATHdocs
            DOCUMENT_TABLEwwv_flow_file_objects$
            PATH_ALIAS
            REQUEST_CHARSETAL32UTF8
            REQUEST_IANA_CHARSETUTF-8
            SCRIPT_PREFIX

             

              

             

            Database version

             

             

            • CORE 12.1.0.1.0 Production  
            • NLSRTL Version 12.1.0.1.0 - Production  
            • Oracle Database 12c Release 12.1.0.1.0 - 64bit Production  
            • PL/SQL Release 12.1.0.1.0 - Production  
            • TNS for 64-bit Windows: Version 12.1.0.1.0 - Production  

             

             

            Character Set

             

            NLS_CHARACTERSET:WE8MSWIN1252
            DAD CHARACTERSET:UTF-8
            JOB_QUEUE_PROCESSES:1000

             

            fac586 wrote:

             

            LT.ora wrote:

             

            I'm not able to display NVARCHAR2 data in Apex 4.2 the data is visible in database

            Untitled.png

            Please provide the following information (as text, not screenshots):

             

            • Full details of your environment (most of this information can be found in the "About Application Express" dialog (? > About on the App Builder toolbar)
            • The results of executing select * from nls_database_parameters in SQL Workshop
            • The values of the following application globalization attributes:
              • Application Primary Language
              • Application Language Derived From
            • The browser language settings
            • 3. Re: Display an NVARCHAR2 data in Apex 4.2
              fac586

              LT.ora wrote:

               

              I'm not able to display NVARCHAR2 data in Apex 4.2 the data is visible in database

              Untitled.png

              It is not possible to successfully render this data through APEX: APEX and UTF-8 FAQ around?

              1 person found this helpful