title: Oracle APEX 19.2 character encoding in app builder problem
body: <p>I have a problem with encoding in ORACLE APEX app builder.
  When I'm using a app builder and creating for example a list with entry with polish native chars for example "Otwórz". When i save it it appears on list as "OtwA3rz". So I'm thinking about problem with encoding, but when i use "Grid Edit" on list I can easily use "Otwórz" and save it properly. After that there is a problem with edit this entry in form. Additionally when I create a form with for example textarea in my app there is no problem to save a value with polish chars. There is only a problem with app builder.</p>
  
  <p>Some info from "About Application Express" modul:</p>
  
  <blockquote>
    <p>• Product Build   19.2.0.00.18</p>
    
    <p>• Schema Compatibility    2019.10.04</p>
    
    <p>• Last DDL Time   02/05/2020 01:09:01 PM</p>
    
    <p>• Host Schema APEX_PUBLIC_USER</p>
    
    <p>• Application Owner   APEX_190200</p>
    
    <p>• Language Preference en</p>
    
    <p>• Current Time (on server)    03/16/2020 02:17:08 PM +01:00   </p>
    
    <p>• APEX_LISTENER_VERSION   19.2.0.r1991647</p>
    
    <p>• PLSQL_GATEWAY   WebDb</p>
    
    <p>• GATEWAY_IVERSION    3</p>
    
    <p>• SERVER_SOFTWARE Mod-Apex</p>
    
    <p>• GATEWAY_INTERFACE   CGI/1.1</p>
    
    <p>• REQUEST_METHOD  GET</p>
    
    <p>• QUERY_STRING    p=4350:9:956788024708&amp;p_dialog_cs=e6pVbBxXQReCPpEOwNEhrbAjoGPeY7nX6VVuLL8ObTSnXKlihOrJCOR8f1EU9isYxMT5Ooqgb-j9A33Mmx1aKA</p>
    
    <p>• PATH_INFO   /f</p>
    
    <p>• HTTP_USER_AGENT Mozilla/5.0 (Windows NT 10.0; WOW64)
    AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.121
    Safari/537.36</p>
    
    <p>• HTTP_ACCEPT_ENCODING    gzip, deflate, br</p>
    
    <p>• HTTP_ACCEPT_LANGUAGE    pl-PL,pl;q=0.9,en-US;q=0.8,en;q=0.7</p>
    
    <p>• REQUEST_CHARSET AL32UTF8</p>
    
    <p>• REQUEST_IANA_CHARSET    UTF-8    •  Oracle Database 12c Enterprise
    Edition Release 12.2.0.1.0 - 64bit Production</p>
    
    <p>• CORE    12.2.0.1.0  Production</p>
    
    <p>• NLSRTL Version 12.2.0.1.0 - Production</p>
    
    <p>• PL/SQL Release 12.2.0.1.0 - Production</p>
    
    <p>• TNS for Linux: Version 12.2.0.1.0 - Production</p>
    
    <p>• NLS_CHARACTERSET:   EE8MSWIN1250</p>
    
    <p>• DAD CHARACTERSET:   UTF-8</p>
    
    <p>• JOB_QUEUE_PROCESSES:    15</p>
  </blockquote>
  
  <p>I noticed that when I run a sql <code>select 'ó' from dual</code> the result is exactly 'A3'. I run another <code>select * from V$NLS_PARAMETERS;</code> and maybe find a reason of all of this. NLS_LANGUAGE is AMERICAN. How to change it for POLISH like I have normally database session configured. When I create my own app with globalization setting there is no problem with setting nls_language to Polish. But i don't know how to change it for app builder</p>
  
  <p>I made a additional experiment i run insert into table value 'ł' and select * from v$nls_parameters thru sql_workshop and sql_script: and below are results:
  (syntax parameter:value:method(script or sqlworkshop))</p>
  
  <pre><code>NLS_CALENDAR:GREGORIAN:script
  NLS_CALENDAR:GREGORIAN:sqlworkshop
  NLS_CHARACTERSET:EE8MSWIN1250:script
  NLS_CHARACTERSET:EE8MSWIN1250:sqlworkshop
  NLS_COMP:BINARY:script
  NLS_COMP:BINARY:sqlworkshop
  NLS_CURRENCY:$:script
  NLS_CURRENCY:$:sqlworkshop
  NLS_DATE_FORMAT:mm/dd/yyyy:script
  NLS_DATE_FORMAT:mm/dd/yyyy:sqlworkshop
  NLS_DATE_LANGUAGE:AMERICAN:script
  NLS_DATE_LANGUAGE:AMERICAN:sqlworkshop
  NLS_DUAL_CURRENCY:$:script
  NLS_DUAL_CURRENCY:$:sqlworkshop
  NLS_ISO_CURRENCY:AMERICA:script
  NLS_ISO_CURRENCY:AMERICA:sqlworkshop
  NLS_LANGUAGE:AMERICAN:script
  NLS_LANGUAGE:AMERICAN:sqlworkshop
  NLS_LENGTH_SEMANTICS:BYTE:script
  NLS_LENGTH_SEMANTICS:BYTE:sqlworkshop
  NLS_NCHAR_CHARACTERSET:AL16UTF16:script
  NLS_NCHAR_CHARACTERSET:AL16UTF16:sqlworkshop
  NLS_NCHAR_CONV_EXCP:FALSE:script
  NLS_NCHAR_CONV_EXCP:FALSE:sqlworkshop
  NLS_NUMERIC_CHARACTERS:.,:script
  NLS_NUMERIC_CHARACTERS:.,:sqlworkshop
  NLS_SORT:BINARY:script
  NLS_SORT:BINARY:sqlworkshop
  NLS_TERRITORY:AMERICA:script
  NLS_TERRITORY:AMERICA:sqlworkshop
  NLS_TIMESTAMP_FORMAT:DD-MON-RR HH.MI.SSXFF AM:script
  NLS_TIMESTAMP_FORMAT:DD-MON-RR HH.MI.SSXFF AM:sqlworkshop
  NLS_TIMESTAMP_TZ_FORMAT:DD-MON-RR HH.MI.SSXFF AM TZR:script
  NLS_TIMESTAMP_TZ_FORMAT:DD-MON-RR HH.MI.SSXFF AM TZR:sqlworkshop
  NLS_TIME_FORMAT:HH.MI.SSXFF AM:script
  NLS_TIME_FORMAT:HH.MI.SSXFF AM:sqlworkshop
  NLS_TIME_TZ_FORMAT:HH.MI.SSXFF AM TZR:script
  NLS_TIME_TZ_FORMAT:HH.MI.SSXFF AM TZR:sqlworkshop
  value:A?:sqlworkshop
  value:ł:cript
  </code></pre>
  
  <p>and basically they are the same</p>
  
  <p>next thing i did is running with the same method as previously code for inserting userenv parameter, and below are the differences:</p>
  
  <pre><code>ACTION::script
  ACTION:Processes - point: BEFORE_BOX_BODY:sqlworkshop
  CLIENT_IDENTIFIER:::script
  CLIENT_IDENTIFIER:#MY_LOGIN#:12101284695326:sqlworkshop
  CLIENT_INFO:100001:#MY_LOGIN#:sqlworkshop
  CLIENT_INFO:#MY_LOGIN#:script
  MODULE:APEX_190200/APEX:APP 4500:1200:sqlworkshop
  MODULE:HTML DB:SQL Workshop:Script:test2:script
  </code></pre>