Re: Reference to character set in PL/SQL code - US7ASCII vs AL32UTF8

Posted by ErmanArslansOracleBlog on May 23, 2017; 7:03am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Reference-to-character-set-in-PL-SQL-code-US7ASCII-vs-AL32UTF8-tp2720p2727.html

Seems yes.

Here ->

SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;

VALUE$
--------------------------------------------------------------------------------
AL32UTF8


SQL> CREATE TABLE hr.admin_emp (
         testchar char(1)
);        2    3  

Table created.



SQL> insert into hr.admin_emp values (chr(38));

1 row created.

SQL> commit;

Commit complete.

SQL> select * from hr.admin_emp;

T
-

&