How to save Asian Language Characters into Oracle 19C table?
(1) NLS_CHARACTERSET is AL32UTF8:
SQL> select value from NLS_DATABASE_PARAMETERS where PARAMETER = 'NLS_CHARACTERSET';
VALUE
--------------------------------------------------------------------------------
AL32UTF8
(2) First Name/Last Name were English
SQL> select memberid, firstname, lastname from member where memberid=57548;
MEMBERID FIRSTNAME LASTNAME
---------- ---------------- ----------------------------------
57548 York Chen
(3) Update my Last Name to Chinese Characters:
SQL> update member set firstname='YUEKE', lastname='保险' where memberid=57548;
1 row updated.
SQL> commit;
Commit complete.
(4) The LAST NAME was not saved correctly:
SQL> select memberid, firstname, lastname from member where memberid=57548;
MEMBERID FIRSTNAME LASTNAME
---------- ---------------- ----------------------------------
57548 YUEKE ??
(5) My Question?
How to let my Oracle19C to be able to save most of Asian Language Characters?