Home » SQL & PL/SQL » Client Tools » Language Support in Toad (Toad , 9.5.0.31)
Language Support in Toad [message #637238] Wed, 13 May 2015 07:30 Go to next message
msinha8
Messages: 37
Registered: March 2014
Location: Hyderbad
Member
Hi All,

I have data stored in my table in Chinese, Korean and many other language along with English.

Issue is, When I am trying to execute a Select statement on the table,except English rest all language's values are getting displayed as "(¿)¿¿¿¿".

My DB version is :-
 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production 


Toad Version:-
 9.5.0.31 


Any pointer, to overcome this issue?


Thanks,
Mritunjay
Re: Language Support in Toad [message #637261 is a reply to message #637238] Wed, 13 May 2015 12:52 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
This is not an Oracle issue, but rather a windoze issue.
You can only set one language at a time:
Example:
1. Select My Computer -> Right Click -> Properties -> Advanced -> Environment Variables
2. Add/modify variable NLS_LANG={your selected language}
3. Open Toad and connect to the Database required.
4. Execute the Query required and select Grid Options.
Data Grid Visuals -> Font ->
Select Font Style = Arial Unicode MS (If Arial Unicode MS is not available in your fonts lists, then you need to install this font.
Select Script = {your language}.
5. Click Ok and Execute the Query.
6. To Add Font if font is not available:
Navigation -> Control Panel -> fonts (To add fonts)
Previous Topic: Tool for tracking SQLs in Oracle 11g
Next Topic: How to open Logical Model?
Goto Forum:
  


Current Time: Mon Oct 15 18:14:18 CDT 2018