DCSIMG
Hebrew fonts problem with Oracle on Windows machines - Doron Goldberg

Hebrew fonts problem with Oracle on Windows machines

Can't view Hebrew data stored in your Oracle database using TOAD / PL/SQL developer ?

That, also, is a well known problem with a very usually-it-works solution for Windows users:

In order to be able to view Hebrew fonts properly from Oracle you need to set the NLS_LANG registry key.

The key can be found here:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID\NLS_LANG where ID is the unique number identifying the Oracle home.

The right value of the key for Hebrew fonts is: HEBREW_ISRAEL.IW8MSWIN1255

 

The full explanation + additional information can be found here.

Comments

# re: Hebrew fonts problem with Oracle on Windows machines

Tuesday, May 29, 2007 12:48 PM by oriw

Hi,

I have similar problem with exporting to excel from asp page (& sqlserver), which sometimes convert the hebrew to gebbrish. I didn't find any pattern and I guess it is related to the fonts.

I'm using the command of

Response.ContentType = "application/vnd.ms-excel" and tried to config all charsets,codepage,buffer, etc...

did you ran accross this problem?

Thanks

ori.

# re: Hebrew fonts problem with Oracle on Windows machines

Sunday, June 03, 2007 11:37 AM by Doron Goldberg

Hi Ori,

What about the ContentEncoding?

We use UTF7 in order to export Hebrew to excel files and it works fine.

# re: Hebrew fonts problem with Oracle on Windows machines

Monday, June 04, 2007 4:31 PM by oriw

Hi Doron,

Thanks , it works now.

I guess excel works better with unicode than windows-1255.

# re: Hebrew fonts problem with Oracle on Windows machines

Sunday, May 18, 2008 11:09 AM by yossi

thanks a lot thats helpfull

# re: Hebrew fonts problem with Oracle on Windows machines

Tuesday, December 02, 2008 6:09 PM by tmyeswteby

OuTao4  <a href="ngfmykmrcnkh.com/.../a>, [url=http://mllceisrebmj.com/]mllceisrebmj[/url], [link=http://togyfhmcdjoy.com/]togyfhmcdjoy[/link], http://aquzldsjlvfb.com/

# re: Hebrew fonts problem with Oracle on Windows machines

Monday, November 09, 2009 3:33 PM by Shalom

thanks! that was really helpful!

Leave a Comment

(required) 
(required) 
(optional)
(required) 

Enter the numbers above: