Home » Other » General » Issue with sending Swedish characters to table via SQLPLUS (12c Enterprise Edition Release 12.1.0.2.0 - 64bit)
Issue with sending Swedish characters to table via SQLPLUS [message #665938] Tue, 03 October 2017 23:00
rit_netsys
Messages: 1
Registered: October 2017
Junior Member
We are using Oracle 12C database with below settings -

select * from nls_database_parameters where parameter like '%CHARACTERSET';

NLS_NCHAR_CHARACTERSET UTF8
NLS_CHARACTERSET AL32UTF8


Oracle client Variable set to - NLS_LANG = AMERICAN_AMERICA.AL32UTF8

Windows Environment Variable set to - NLS_LANG = AMERICAN_AMERICA.AL32UTF8

Now we are trying to insert Swedish characters to table via SQLPLUS -

INSERT INTO gen_barium_ucc_src_t (MI_INPUT_ID, "NAME", LOGIN_ID, USER_EMAIL, CC, STATUS, "ROLE", INS_DTIME ) VALUES ('96', 'Susanne Svärd', 'SUSA', 'S@abc', 'CC00007', 'ACTIVE', 'DEV', SYSDATE );

While checking the same with SQL PLUS, it is showing Swedish characters perfectly.

But while checking the same with SQL Developer GUI, it is not showing Swedish Characters properly in table. It is showing as "?".

Then I tried to insert the same with SQL Developer GUI. Here Table is accepting Swedish characters properly.

Is there something I am missing?

/forum/fa/13658/0/
Previous Topic: Help me to understand MVD
Next Topic: The Autonomous "Self-Driving" Database
Goto Forum:
  


Current Time: Thu Mar 28 05:07:13 CDT 2024