OS : RHEL 7.9
Oracle DB version: 19c
I am running the below test from DB server so I am using the SQL*Plus that comes with 19c Oracle DB software.
In the below example, although I inserted French characters, when I try to query it, I get question mark symbols instead of French characters.
$ sqlplus scot/Rmstn#845@10.76.18.178:1521/PDB_HRMS
SQL> create table test3 (name varchar2(25 char), months varchar2(25 char));
Table created.
SQL> insert into test3 values ('mélodie-gîmë', 'août');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test3;
NAME MONTHS
------------------------- -------------------------
m??lodie-g??m?? ao??t
SQL> exit
So, I set NLS_LANG variable at OS level (Red Hat Linux) as shown below. But now, junk characters appear instead of French characters.
$ export NLS_LANG=FRENCH_FRANCE.AL32UTF8
$ sqlplus scot/Rmstn#845@10.76.18.178:1521/PDB_HRMS
SQL> col name for a20
SQL> col months for a10
SQL> select * from test3;
NAME MONTHS
-------------------- ----------
m��lodie-g��m�� ao��t
SQL>
It is not correctly displayed in SQL Developer either. It appears like below
Any idea how I can get the French characters displayed in SQL*Plus ?
Additional info:
Databases uses AL32UTF8 characterset.
SQL> alter session set container = PDB_HRMS;
Session altered.
SQL> select value,parameter from NLS_DATABASE_PARAMETERS where PARAMETER like '%CHARACTERSET';
VALUE PARAMETER
------------------------- -----------------------------------
AL16UTF16 NLS_NCHAR_CHARACTERSET
AL32UTF8 NLS_CHARACTERSET