PL/SQL and Greek

[iraklisvai]

Hello,
I have installed pl/sql developer v 12.0.7.1837 on my pc. All are ok.
When I installed it, on a Windows 2008 Server Remote Desktop Connection, with the same preferences, it does not understand Greek. I mean, when i make a select * from tableA, if tableA has colums with Greek names, it displays ???? instead of the name.
When I connect to this database from my pc, and I make the same select statement, all are ok.

I have looked at Preferences, Fonts, Main Font, Script is Greek.
I have also looked at regional settings, all are Greek.
I have also look at regedit, NLS_LANG parameter is AMERICAN_AMERICA.EL8ISO8859P7
Finally, both pl/sql Developers have the same client.

What is wrong?

Thank you very much.

Thank you very much.

 

[Arky]

Hello Irakli,

What is the setting at
Language Settings -> Administrative Language Settings -> Language for Non-Unicode Programs ? It should be Greek too (I think)

Aris

 

[iraklisvai]

it is also Greek ( Current System Locale)

 

[Marco Kalter]

Maybe this is an environment problem. Can you start PL/SQL Developer, connect to this database, go to Help > Support Info and send me the text from the "Info" tab page?

 

[iraklisvai]

PL/SQL Developer
Version 12.0.7.1837 (64 bit)
01.276182 - Unlimited user license
Service Contract:
Windows 7 Build 7601 (Service Pack 1)

Physical memory : 25.165.368 kB (6.708.528 available)
Paging file : 50.328.876 kB (28.095.464 available)
Virtual memory : 8.589.934.464 kB (8.589.567.072 available)

Parameters
C:\Program Files\PLSQL Developer 12\plsqldev.exe
InstantClient=C:\Oracle\instantclient_10_2

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Program Files\PLSQL Developer 12\Preferences\Default\Default.ini
C:\Users\IR\AppData\Roaming\PLSQL Developer 12\Preferences\Vaindirlis\default.ini

License File
C:\ProgramData\PLSQL Developer\aalf.dat

Debug file
C:\Program Files\PLSQL Developer 12\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer 12\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer 12\PlugIns\plsqldoc.dll)
(* is Active)

Aliases
APD
APD.IKA4
Beq-local.world
bidb
bidb_contr_ops
...

Homes

DLLs
c:\oracle\instantclient_10_2\oci.dll

TNS File
C:\Oracle\instantclient_10_2\tnsnames.ora

Using
Home:
DLL: C:\Oracle\instantclient_10_2\oci.dll
OCI: Version 10.2 (10.2.0.5.0)
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0

Character Sets
Character size: 1 byte(s)
CharSetID: 37
NCharSetID: 2000
Unicode Support: True
NLS_LANG:
NLS_CHARACTERSET: EL8ISO8859P7
NLS_NCHAR_CHARACTERSET: AL16UTF16

Process
Working Set = 138.014.720
Memory = 46.992.032
GDI Objects = 741
User Objects = 382
Handles = 208

Monitor
PixelsPerInch = 96

Id = 0
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1680
Height = 1050

MainFormOnTaskbar = False

 

[iraklisvai]

I think i found the reason. But why?
In Remote PC
NLS_LANG:

In my PC

NLS_LANG: AMERICAN_AMERICA.EL8ISO8859P7

Thank you very much.

 

[Marco Kalter]

That is indeed the reason. For the Oracle Instant Client you need to set the NLS_LANG environment variable on the PC.

 

[Nick Panoussis]

NLS_LANG is the variable that Oracle client checks in order to perform (any) translation between server and client.

For MS Windows clients you need EL8MSWIN1253, for UX usually EL8ISO8859P7 will do.