Hello,
I'm trying to retrieve data from remote Oracle database which contains data in Hebrew. I'm using SQL Developer 4.0.1 for this purpose and getting the Hebrew letters displayed as junk.
Some details:
1) Oracle DB version (SELECT * FROM V$VERSION):
Oracle Database 10g Release 10.2.0.1.0 - 64bit Production
PL/SQL Release 10.2.0.1.0 - Production
"CORE 10.2.0.1.0 Production"
TNS for 64-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
2) DB server OS - Windows Server 2003, 64 bit.
3) OS, that I work on (running SQL Developer) - Windows 7 Professional, 64 bit.
4) An Example of the problem
This query:
Select LOCAL_NAME
From ITEMSECT
Where ITEMSECT.CODE_NO in (40001,40002)
Gave me this:
ùéåå÷
îåñãé
Actually it must be (In such a way we see it in ERP):
שיווק
מוסדי
5) The data inputted in ERP (our operational enterprise management system) in Hebrew and stored in the DB, from which I am trying to retrieve the data. In this ERP the data is stored properly.
Several BI tools (like Qlikview), which use the data from the DB also display it in a proper way.
I must note, that I am not a DBA person and my knowledge of databases is very limited.
After searching the internet for this issue, I found out that this may be due to NLS settings incompatibilities between database, client and the application I am using (SQL Developer).
I ran the command:
Select *
From nls_database_parameters
and got the following:
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CHARACTERSET WE8MSWIN1252
NLS_NCHAR_CHARACTERSET AL16UTF16
Running the command:
Select * From nls_session_parameters
doesn't give no row with NLS_CHARACTERSET (If I'm understanding it right - it should let me know the client charset).
Really appreciate your help with further steps for resolving this issue.
I'll be glad to give you more information if needed.