Re: PROBLEM NATIONAL CHARACTER

Posted by ErmanArslansOracleBlog on Aug 21, 2017; 12:11pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/PROBLEM-NATIONAL-CHARACTER-tp3260p3262.html

Hi,

1)What is that character ? (chiness? arabic? ...)

2)What is the tool that you are using for querying the database?

3)What is the client that you are using (windows, mac, linux ...) is it able to show those characters?

4)What is the characterset of your database? Does it include your problematic character?
send me the output of the following sql: (send it in a formatted way)

set linesize 1000
col "SESSION" format a30
col DATABASE  format a30
col INSTANCE  format a30
select * from
(select 'SESSION' SCOPE,nsp.* from nls_session_parameters nsp
union
select 'DATABASE' SCOPE,ndp.* from nls_database_parameters ndp
union
select 'INSTANCE' SCOPE,nip.* from nls_instance_parameters nip
) a
pivot  (LISTAGG(VALUE) WITHIN GROUP (ORDER BY SCOPE)
FOR SCOPE
in ('SESSION' as "SESSION",'DATABASE' as DATABASE,'INSTANCE' as INSTANCE));