SQL> select *  from v$version;

BANNER
--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL> SELECT * from NLS_DATABASE_PARAMETERS WHERE parameter IN ( 'NLS_LANGUAGE',
'NLS_TERRITORY', 'NLS_CHARACTERSET');

PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------

NLS_LANGUAGE
AMERICAN

NLS_TERRITORY
AMERICA

NLS_CHARACTERSET
ZHS16GBK

SQL> show parameter nls_lang

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_language                         string      SIMPLIFIED CHINESE

 select distinct CLIENT_CHARSET from v$SESSION_CONNECT_INFO where CLIENT_CHARSET != 'Unknown';

SQL> select distinct CLIENT_CHARSET from v$SESSION_CONNECT_INFO where CLIENT_CHA
RSET != 'Unknown';

CLIENT_CHARSET
----------------------------------------
WE8MSWIN1252

SQL> select distinct CLIENT_CHARSET from v$SESSION_CONNECT_INFO where CLIENT_CHA
RSET != 'Unknown';

CLIENT_CHARSET
----------------------------------------
WE8MSWIN1252

create table t (c varchar2(10 char));
begin
  insert into t 
  select translator ('table and chair','zh-CN','en') English_to_chinese from dual ;
end;
/
select dump(c) from t;

SQL> begin
  2    insert into t
  3    select translator ('table and chair','zh-CN','en') English_to_chinese fro
m dual ;
  4  end;
  5  /

PL/SQL procedure successfully completed.

SQL> select dump(c) from t;

DUMP(C)
--------------------------------------------------------------------------------

Typ=1 Len=10: 215,192,215,211,186,205,210,206,215,211