| 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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
