Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center