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