SQLplus and Oracle, bad UTF-8 display
4
votes
2
answers
8399
views
I have set
export NLS_LANG=Italian_ITALY.UTF8
db is on UTF-8
SELECT * FROM NLS_DATABASE_PARAMETERS
NLS_CHARACTERSET |AL32UTF8
But sqlplus displays bad
ò
à
ì
characters.
select titolo from generale where titolo like '%%Roma d%%';
TITOLO
------------------------------------------------------------
Roma drogata: la polizia non pu�� intervenire
must be
select titolo from generale where titolo like '%%Roma d%%';
TITOLO
------------------------------------------------------------
Roma drogata: la polizia non può intervenire
I have tried AIX and Linux client, all on UTF-8.
What do I miss?
Asked by elbarna
(13710 rep)
May 19, 2015, 09:00 PM
Last activity: Sep 4, 2018, 11:01 AM
Last activity: Sep 4, 2018, 11:01 AM