Since new freeware version Toad 10.5 for oracle I cannot see Hebrew letters .There wasn’t such a problem in previous versions of Toad.
What can I do ? Is there any parameters or properties that i can change, or this new “much more advanced” version doesn’t support Hebrew. If somebody knows please answer.
Michael.
In the editor, in the grids, both?
Perhaps you could share your NLS settings for the database, and let us know
which font you’re using for both editor and grids?
Jeff
actually this is the first version of Freeware to offer full unicode support. In the past, it had patch work support, here and there. So you could get away with things not being set up properly.
Your first thing to check - open up Help > Toad Advisor. See if it tells you if your local NLS_LANG value is correct. This is the most common cause of problems. your client NLS_LANG must match your client character set (not the database character set - a common misconception)
to my recollection we have full Hebrew support throughout, but we spent the majority of our time on non bidirectional languages
if you want to chnage the character set in Oracle
sqlplus>ALTER DATABASE CHARACTER SET IW8MACHEBREW
also you will want to change NLS_LANGUAGE and NLS_TERRITORY
http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm#_To
c110410553
shalom!
Martin Gainty
Note de déni et de confidentialité
Ce message est confidentiel et peut être privilégié. Si vous n’êtes pas le
destinataire prévu, nous te demandons avec bonté que pour satisfaire informez
l’expéditeur. N’importe quelle diffusion non autorisée ou la copie de ceci est
interdite. Ce message sert à l’information seulement et n’aura pas n’importe
quel effet légalement obligatoire. Étant donné que les email peuvent
facilement être sujets à la manipulation, nous ne pouvons accepter aucune
responsabilité pour le contenu fourni.
Thank you for reply.
Yes, Toad advisor warns me about incorrect NLS_LANG( I use AMERICAN_AMERICA.WE8MSWIN1252) , but when I changed to suggested value(HEBREW_ISRAEL.IW8MSWIN1255) , it affects my Delphi applications.
So , where can I change client character set since I cannot change NLS_LANG ?
Only in the editor.
I cannot change NLS_LANG since it affects my application.
Sorry, only in the grids.
I would install another Oracle client then to a separate home, one for your app,
and one for everything else that needs to connect to oracle and support the
Hebrew environment.
It depends on your operating system. If you are running something pre-Windows 7, control panel > regional & Language options > Advanced tab, ‘Language for non-unicode programs.’
Note that it’s not just Toad which requires these values match, it’s also SQL Plus, any of the Oracle utilities (Loader, exp/imp, etc.) and most other Oracle related tools.
alternatively you can create a separate Oracle Home and set that one and make it active, just be aware you’ll have one Home sitting out there with the wrong NLS_LANG, and data corruption is possible if you use it.
this is all step 1. the other steps are the ones Jeff mentioned earlier - the right font for instance
i was assuming the op was sysdba on the db (and was his to configure as he saw
fit)
Good Advice Jeff!
Martin Gainty
Note de déni et de confidentialité
Ce message est confidentiel et peut être privilégié. Si vous n’êtes pas le
destinataire prévu, nous te demandons avec bonté que pour satisfaire informez
l’expéditeur. N’importe quelle diffusion non autorisée ou la copie de ceci est
interdite. Ce message sert à l’information seulement et n’aura pas n’importe
quel effet légalement obligatoire. Étant donné que les email peuvent
facilement être sujets à la manipulation, nous ne pouvons accepter aucune
responsabilité pour le contenu fourni.