character encoding - difference between NLS_NCHAR_CHARACTERSET abd NLS_CHARACTERSET for Oracle -

-

i have quick question here, know difference between nls_nchar_characterset , nls_characterset setting in oracle ??

from understanding nls_nchar_characterset nvarchar data types , nls_characterset varchar2 data types.

i tried test on development server current settings characterset following :- 

parameter                      value ------------------------------ ---------------------------------------- nls_nchar_characterset         al16utf16 nls_numeric_characters         ., nls_characterset               us7ascii

then inserted chinese character values database. inserted characters table called data_ , updated column address , address_2 varchar2 columns. right understanding current setting nls_characterset us7ascii , chinese characters should not supported still showing in database ?? nls_nchar_characterset take precedence on ??

thank you.

in general points correct. nls_nchar_characterset defines character set nvarchar2, et. al. columns whereas nls_characterset used varchar2.

why possible see chinese characters us7ascii?

the reason is, database character set , client character set (i.e. see nls_lang value) both us7ascii. database uses us7ascii , "thinks" client sends data using us7ascii. not make conversion of strings, data transferred one-to-one client server , vice versa.

due fact can use characters not supported us7ascii. aware, in case client uses different character set (e.g. when use odp.net managed driver in windows application) data rubbish! if consider database character set migration have same issue.

another note: don't think same behavior other character sets, e.g. if database , client both use we8iso8859p1 example. aware have wrong configuration. database uses character set us7ascii, nls_lang value us7ascii (most not set @ , oracle defaults us7ascii) real character set of sql*plus, resp. cmd.exe terminal cp950 or cp936.

if set can either set environment variable nls_lang=.zht16mswin950 (cp936 seems not supported oracle) or change codepage before running sqlplus.exe command chcp 437. proper settings not see chinese characters have expected.


Comments

Post a Comment

Popular posts from this blog

Ansible - ERROR! the field 'hosts' is required but was not set -

-
i've error when launch playbook don't found why.... error! field 'hosts' required not set there main.yml : --- - hosts: hosts - vars: - elasticsearch_java_home: /usr/lib/jmv/jre-1.7.0 - elasticsearch_http_port: 8443 - tasks: - include: tasks/main.yml - handlers: - include: handlers/main.yml and /etc/ansible/hosts : [hosts] 10.23.108.182 10.23.108.183 10.23.108.184 10.23.108.185 when test ping, : [root@poste08-08-00 elasticsearch]# ansible hosts -m ping 10.23.108.183 | success => { "changed": false, "ping": "pong" } 10.23.108.182 | success => { "changed": false, "ping": "pong" } 10.23.108.185 | success => { "changed": false, "ping": "pong" } 10.23.108.184 | success => { "changed": false, "ping": "pong" } please, me :) regards, you have syntax error in playbook.
Read more

customize file_field button ruby on rails -

-
i'm trying rid of ugly button rails has default file upload. want add glyphicon <%= f.file_field :image_url, class:"glyphicon glyphicon-camera" %> this didn't work , have tried other things in different post saw on page, don't attach file. as suggested here bootstrap filestyle , can use bootstrap's filestyle style file upload buttons. step-1: add layout application.html.erb i have added bootstrap filestyle library cdn. should make sure have both jquery , boostrap loaded. <script type="text/javascript" src="https://cdn.jsdelivr.net/bootstrap.filestyle/1.1.0/js/bootstrap-filestyle.min.js"> </script> step-2: add corresponding js file: $(":file").filestyle({input: false}); step-3: image_url file field follows: <%= f.file_field :image_url,class: "filestyle", "data-input" => false %>
Read more

SoapUI on windows 10 - high DPI/4K scaling issue -

-
Image
soapui doesn't seem dpi-aware , displays small on high dpi screen (tiny text , buttons). other applications running fine (screen resolution 3840 x 2160). version : soapui 5.1.2 os : windows 10 i have tried: configure soapui run "disable display scaling on high dpi settings" - parts of soapui looking bigger , don't display (image) changing resolution changing font size (preferences > editor settings > select font...) therefore assume, soapui pretends dpi-aware, not scale itself. have same issue? this workaround until developers round making version dpi-aware. step 1: add registry key hkey_local_machine\software\microsoft\windows\currentversion\sidebyside\preferexternalmanifest (dword) 1 step 2: add manifest file 'soapui-5.2.1.exe.manifest' in same directory 'soapui-5.2.1.exe' content of manifest file: <?xml version="1.0" encoding="utf-8" standalone="yes"?> <assembly xml
Read more