Wrong encoding to the results of a query

[Eleftherios]

Hi all,

I searched through te blog and I could not find a solution for this issue, although it might be a FAQ. I am from Greece, so my database includes many greek characters. When i query
to get the results I am getting '????' as a result. I changed many times the nls_lang at my registry, but nothing helped.
The reuslts of the query SELECT * FROM V$NLS_PARAMETERS; are the following:

"PARAMETER","VALUE"
"NLS_LANGUAGE","AMERICAN"
"NLS_TERRITORY","AMERICA"
"NLS_CURRENCY","$"
"NLS_ISO_CURRENCY","AMERICA"
"NLS_NUMERIC_CHARACTERS",".,"
"NLS_CALENDAR","GREGORIAN"
"NLS_DATE_FORMAT","DD-MON-RR"
"NLS_DATE_LANGUAGE","AMERICAN"
"NLS_CHARACTERSET","EL8ISO8859P7"
"NLS_SORT","BINARY"
"NLS_TIME_FORMAT","HH.MI.SSXFF AM"
"NLS_TIMESTAMP_FORMAT","DD-MON-RR HH.MI.SSXFF AM"
"NLS_TIME_TZ_FORMAT","HH.MI.SSXFF AM TZR"
"NLS_TIMESTAMP_TZ_FORMAT","DD-MON-RR HH.MI.SSXFF AM TZR"
"NLS_DUAL_CURRENCY","$"
"NLS_NCHAR_CHARACTERSET","AL16UTF16"
"NLS_COMP","BINARY"
"NLS_LENGTH_SEMANTICS","BYTE"
"NLS_NCHAR_CONV_EXCP","FALSE"

My current NLS_LANG is American_America.EL8MSWIN1253 I have tried and the GREEK_GREECE.EL8MSWIN1253 but didn't work.
The database is oracle 11g and the client is pl/sql developer version is 12.04. The toad is working, but I prefer to use pl/sql developer.
At region and language at format tab I have English, at location tab I have Greece and for non unicode programs I have Greek.

Thanks in advance

 

[Marco Kalter]

Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[Eleftherios]

It worked by doing the following

-closing PL/SQL Dev
-set NLS_LANG=GREEK_GREECE.AL32UTF8 as a system environment variable (remove your previous vars/reg entries)
-reboot for the sake of it
-re-open PL/SQL.