| Language Support in Toad [message #637238] |
Wed, 13 May 2015 07:30  |
 |
msinha8
Messages: 43
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:-
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  |
 |
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)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
