Sample Header Ad - 728x90

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