export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
> sqlplus / as sysdba
SQL> select value10 from tab1 where config_name like '%SMS_TEMP%' AND VALUE1='132';
VALUE10
--------------------------------------------------------------------------------
亲爱的顾客
Monday, January 08, 2018
Insert Chinese character into Oracle database
My database character is AL32UT8. Below works for me.
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
> sqlplus / as sysdba
SQL> select value10 from tab1 where config_name like '%SMS_TEMP%' AND VALUE1='132';
VALUE10
--------------------------------------------------------------------------------
亲爱的顾客
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
> sqlplus / as sysdba
SQL> select value10 from tab1 where config_name like '%SMS_TEMP%' AND VALUE1='132';
VALUE10
--------------------------------------------------------------------------------
亲爱的顾客
