| Hebrew displayed as junk [message #616002] |
Wed, 11 June 2014 09:01  |
 |
Analyst
Messages: 45
Registered: June 2014
|
Member |
|
|
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.
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
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 needed.
|
|
|
|
|
|
|
|
| Re: Hebrew displayed as junk [message #616009 is a reply to message #616002] |
Wed, 11 June 2014 09:37  |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
Analyst wrote on Wed, 11 June 2014 19:31The 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).
Perhaps you wanted :
SELECT * FROM v$nls_parameters WHERE parameter LIKE '%CHARACTERSET%';
|
|
|
|
|
|
| Re: Hebrew displayed as junk [message #616012 is a reply to message #616011] |
Wed, 11 June 2014 09:56 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
since you have not actually shown us the SELECT you issue, I can only generalize what you need to do
SELECT ASCIISTR(HEBREW_COL), HEBREW_COL FROM HEBREW_TBL WHERE PK = <KNOWN_VALUE>;
COPY & PASTE your actual query & post results back here.
[Updated on: Wed, 11 June 2014 09:57] Report message to a moderator |
|
|
|
|
|
| Re: Hebrew displayed as junk [message #616018 is a reply to message #616013] |
Wed, 11 June 2014 10:37 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
Browser might be capable of displaying Hebrew, but your client tool might not. Where are you able to view hebrew properly?
Anorher thing, since when are you facing this issue? Were any changes done recently? Consult your DBA and probe these questions.
[Updated on: Wed, 11 June 2014 10:51] Report message to a moderator |
|
|
|
| Re: Hebrew displayed as junk [message #616021 is a reply to message #616013] |
Wed, 11 June 2014 10:48 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:Actually it must be
Not possible with WE8MSWIN1252.
For instance, character F9 in WE8MSWIN1252 is:
SQL> select value from nls_database_parameters where parameter='NLS_CHARACTERSET';
VALUE
----------------------------------------
WE8MSWIN1252
SQL> select chr(to_number('F9','XX')) from dual;
C
-
ù
Quote:In such a way we see it in ERP
This is because your ERP is wrongly parametrized. It says to Oracle it works in WE8MSWIN1252 but actually works and displays in another character set.
[Updated on: Wed, 11 June 2014 10:49] Report message to a moderator |
|
|
|
| Re: Hebrew displayed as junk [message #616024 is a reply to message #616018] |
Wed, 11 June 2014 11:24 |
|
Analyst
Messages: 45
Registered: June 2014
|
Member |
|
|
Quote:Where are you able to view hebrew properly?
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.
The BI tools (like Qlikview), which use the data from the DB also display it in a proper way.
Quote:Anorher thing, since when are you facing this issue? Were any changes done recently? Consult your DBA and probe these questions.
I recently joined the company and the issue faced since they started to use SQL Developer (more than a year). There is no real DBA to consult with.
Quote:his is because your ERP is wrongly parametrized. It says to Oracle it works in WE8MSWIN1252 but actually works and displays in another character set.
Do I have a way to resolve it on my client tool without changing the parameters of ERP?
Note that in BI tools I see it properly as well.
[Updated on: Wed, 11 June 2014 11:24] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Hebrew displayed as junk [message #616284 is a reply to message #616129] |
Sun, 15 June 2014 01:43 |
|
Analyst
Messages: 45
Registered: June 2014
|
Member |
|
|
I launched cmd.exe and ran the command, you mentioned:
set AMERICAN_AMERICA.WE8MSWIN1252
<My sqldeveloper path>\sqldeveloper.exe
Getting the following message:
Environmental variable AMERICAN_AMERICA.WE8MSWIN1252
<My sqldeveloper path>\sqldeveloper.exe not defined
[Updated on: Sun, 15 June 2014 01:52] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Hebrew displayed as junk [message #616308 is a reply to message #616306] |
Sun, 15 June 2014 09:30 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
Analyst wrote on Sun, 15 June 2014 19:47I am getting the following:
The system cannot find the file specified.
How could it be? I copied the path from the properties of the original .exe file.
1. Go to All Programs from Start.
2. Click Oracle home folder.
3. Click application development folder.
4. Right click on sql developer, go to properties, copy target file path.
|
|
|
|
| Re: Hebrew displayed as junk [message #616309 is a reply to message #616306] |
Sun, 15 June 2014 09:41 |
flyboy
Messages: 1903
Registered: November 2006
|
Senior Member |
|
|
Maybe it is time to get acquainted with your operating system as well... or stop using spaces in directory names.
http://www.computerhope.com/issues/ch001477.htm
Quote:In the Windows command line any file or directory that contains a space must be surrounded with quotation marks in order for it to be recognized.
...
The reason the quotation marks are needed on files with spaces is that the command line doesn't know where the file name begins or ends without them, due to the spaces.
...
C:\Users\Flyboy>cd c:/work
c:\Work>mkdir "Test AAA"
c:\Work>dir C:\work\Test AAA\
The system cannot find the file specified.
c:\Work>dir "C:\work\Test AAA\"
Volume in drive C is Windows
Volume Serial Number is D8B7-68E2
Directory of C:\work\Test AAA
15.06.2014 16:35 <DIR> .
15.06.2014 16:35 <DIR> ..
0 File(s) 0 bytes
2 Dir(s) 337 059 303 424 bytes free
c:\Work> |
|
|
|
| Re: Hebrew displayed as junk [message #616310 is a reply to message #616308] |
Sun, 15 June 2014 10:12 |
|
Analyst
Messages: 45
Registered: June 2014
|
Member |
|
|
1. Go to All Programs from Start.
2. Click Oracle home folder.
3. Click application development folder.
4. Right click on sql developer, go to properties, copy target file path.
I said, that my technical knowledge in computing is limitted.
The path, that I get following your instructions:
C:\app\Analyst\product\12.1.0\dbhome_1\sqldeveloper\sqldeveloper\bin\sqldeveloperW.exe
Now that is what I wrote in cmd.exe:
set AMERICAN_AMERICA.WE8MSWIN1252
C:\app\Analyst\product\12.1.0\dbhome_1\sqldeveloper\sqldeveloper\bin\sqldeveloperW.exe
There are no spaces in the directory name now, but I still get the same message:
Environmental variable AMERICAN_AMERICA.WE8MSWIN1252
C:\app\Analyst\product\12.1.0\dbhome_1\sqldeveloper\sqldeveloper\bin\sqldeveloperW.exe not defined
[Updated on: Sun, 15 June 2014 10:21] Report message to a moderator |
|
|
|
| Re: Hebrew displayed as junk [message #616311 is a reply to message #616310] |
Sun, 15 June 2014 11:02 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
Analyst wrote on Sun, 15 June 2014 20:42
C:\app\Analyst\product\12.1.0\dbhome_1\sqldeveloper\sqldeveloper\bin\sqldeveloperW.exe
Can you launch Sql developer from cmd, and tell us whether it opens up or not.
1. Open cmd
2. Copy this C:\app\Analyst\product\12.1.0\dbhome_1\sqldeveloper\sqldeveloper\bin\sqldeveloperW.exe
3. Paste it in cmd using right click on top and click paste.
4. Press enter and see whether sql developer is launched.
|
|
|
|
|
|
|
|
| Re: Hebrew displayed as junk [message #616314 is a reply to message #616312] |
Sun, 15 June 2014 11:20 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
Analyst wrote on Sun, 15 June 2014 21:38I'm getting pop-up window with Oracle SQL Developer in the title and the following message in it:
Enter the full pathname for java:exe
Seems to be an issue with JDK. You said that you saw junk characters in sql developer, means you were already using the tool. But now you are unable to open it via cmd. Is the same error thrown while you open it directly?
|
|
|
|
| Re: Hebrew displayed as junk [message #616315 is a reply to message #616314] |
Sun, 15 June 2014 11:25 |
|
Analyst
Messages: 45
Registered: June 2014
|
Member |
|
|
No, directly it's opened correctly.
And I am able to open it using cmd.exe when I copy there the following path (the one I posted here before):
"C:\Users\Analyst\Desktop\DB\Programs\Oracle SQL Developer\sqldeveloper.exe"
I think that I have SQL Developer installed in 2 places.
I installed Oracle db on my client in this path:
C:\app\Analyst\product\12.1.0\dbhome_1\
And I also unpacked SQL Developer to this path:
C:\Users\Analyst\Desktop\DB\Programs\Oracle SQL Developer\
Should I try to delete one of them?
[Updated on: Sun, 15 June 2014 11:28] Report message to a moderator |
|
|
|
|
|
| Re: Hebrew displayed as junk [message #616317 is a reply to message #616316] |
Sun, 15 June 2014 11:53 |
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
|
Senior Member |
|
|
Coming back to your problem with environment variable not defined while following Michel's steps, can you do this check :
In WIndows 7,
1. Right click on My computer.
2. Go to properties.
3. Go to Advanced system settings on left pane.
4. In system properties, click Environment variables.
5. In system variables below, select the PATH.
6. Click on edit, copy paste it back here.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
