Home » SQL & PL/SQL » Client Tools » Language Support in Toad (Toad ,
Language Support in Toad [message #637238] Wed, 13 May 2015 07:30 Go to next message
Messages: 42
Registered: March 2014
Location: Hyderbad
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 - 64bit Production 

Toad Version:- 

Any pointer, to overcome this issue?

Re: Language Support in Toad [message #637261 is a reply to message #637238] Wed, 13 May 2015 12:52 Go to previous message
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:
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: Sun Jun 13 12:37:33 CDT 2021