Home » Other » Client Tools » Hebrew displayed as junk (SQL Developer, 4.0.2)
Re: Hebrew displayed as junk [message #616353 is a reply to message #616348] Mon, 16 June 2014 02:23 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Analyst wrote on Mon, 16 June 2014 12:15
Pasting the text in the "PATH":

C:\app\Analyst\product\12.1.0\dbhome_1\bin


So the path in your windows system variable is the directory where the DB resides. I am not sure whether sql developer path needs to be present there, but to open any executable program without mentioning the fullpath in command line, the path must be defined in system variables in the environment variables.
Re: Hebrew displayed as junk [message #616354 is a reply to message #616353] Mon, 16 June 2014 02:29 Go to previous messageGo to next message
Analyst
Messages: 45
Registered: June 2014
Member
It is a local database, not the DB with which I have an issue. This local DB was installed for my own checks and tests.
The DB, on which there is a problem with Hebrew letters is a remote one.

[Updated on: Mon, 16 June 2014 02:30]

Report message to a moderator

Re: Hebrew displayed as junk [message #616364 is a reply to message #616354] Mon, 16 June 2014 03:23 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
You need to add the sqldeveloper path in the environment variable and follow Michel's step again. Remember that the path you use in the command line should be exactly same as that of the environment variable PATH.
Re: Hebrew displayed as junk [message #616549 is a reply to message #616364] Wed, 18 June 2014 03:51 Go to previous messageGo to next message
Analyst
Messages: 45
Registered: June 2014
Member
I did it, getting the same message:

Environmental variable AMERICAN_AMERICA.WE8MSWIN1252 "C:\Users\Analyst\Desktop\DB\Programs\Oracle SQL Developer" not defined


When I tried the following command:

DIR "C:\Users\Analyst\Desktop\DB\Programs\Oracle SQL Developer"


I've gotten a long message:

Volume in drive C is OS
Volume Serial number is...

Directory of C:\Users\Analyst\Desktop\DB\Programs\Oracle SQL Developer
 
 18/JUN/2014 11:35 <DIR> .
 18/JUN/2014 11:35 <DIR> ..
 18/JUN/2014 10:15 <DIR> configuration
 and so on... 


It means, that the directory is recognized, no? What may be wrong with the Environmental variable. As you recommended, I copied the same path to the PATH system variable:

C:\Users\Analyst\Desktop\DB\Programs\Oracle SQL Developer\


I would like to note, that I don't have any Oracle database installed now on my computer, just SQL Developer, which is connected to remote DB, with which I have the Hebrew problem.

[Updated on: Wed, 18 June 2014 03:52]

Report message to a moderator

Re: Hebrew displayed as junk [message #616581 is a reply to message #616129] Wed, 18 June 2014 11:54 Go to previous messageGo to next message
thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC
Member

Instead of setting this at the cmd-line, you can set this in the preferences.

I've seen this problem most frequently where the editor font isn't set to something that can display the characters.
Re: Hebrew displayed as junk [message #616587 is a reply to message #616581] Wed, 18 June 2014 12:20 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Hi Jeff,

I was hoping for your comment on this topic.

Just curious to know, do you have an idea, with exactly same client settings and OS environment settings, I have no issues opening SQL Developer, but OP has an issue opening the tool from command prompt. You can have a look at my suggestions/steps above.

Regards,
Lalit
Re: Hebrew displayed as junk [message #616615 is a reply to message #616581] Thu, 19 June 2014 01:25 Go to previous messageGo to next message
Analyst
Messages: 45
Registered: June 2014
Member
thatjeffsmith wrote on Wed, 18 June 2014 19:54
Instead of setting this at the cmd-line, you can set this in the preferences.

I've seen this problem most frequently where the editor font isn't set to something that can display the characters.


Hi, Jeff.

What preferences should I set?
In SQL Developer I have the following:
Tools>Preferences>Environment>Encoding>Cp1252


Re: Hebrew displayed as junk [message #616878 is a reply to message #616615] Sun, 22 June 2014 02:24 Go to previous message
Analyst
Messages: 45
Registered: June 2014
Member
Good Day.
I've gotten this solution from Oracle Community forum and it works:

Quote:
You can attempt the following cumbersome workaround to view the data (2000 byte strings max because of the RAW size limit):
SELECT utl_i18n.raw_to_nchar(utl_i18n.string_to_raw(column_name),'IW8MSWIN1255') FROM table_name;
This will attempt to pass the data as NCHAR data, which is Unicode and supports Hebrew.


I didn't find a way to set my client to display Hebrew without using the workaround above.
If you think, there is such a way, I will thank you very much.
Previous Topic: Exporting data with Scheduled job
Next Topic: Unable to see database list in dropdown of pl/sql developer
Goto Forum:
  


Current Time: Thu Mar 28 17:09:55 CDT 2024