If I try to insert or display Chinese characters in the Schema Browser's Data Grid they are displayed as inverted question marks. How can I get TOAD International to display the Chinese characters correctly.
Make the following changes:
- Open TOAD
- Go to View | Options | Data Grids - Visual
- Uncheck "Restore MS Shell Dlg 2 font"
- Click the Font button under the "Preview Column" frame.
- Set the font to "@Arial Unicode MS" and set the Script in the drop down list to "CHINESE_BIG5". Ok the changes.
- Click the Font button under the "Fonts" frame.
- Set the font to "@Arial Unicode MS" and set the Script in the drop down list to "CHINESE_BIG5". Ok the changes.
- OK all the changes in the options.
You must now change the character set for the local machine.
- Open RegEdit from Start Menu | Run and entering RegEdit.
- Drill down to HKEY_LOCAL_MACHINE | Software | Oracle | HomeX. Where HomeX is your current Oracle home in use.
- Double click the NLS_LANG string value under the home. See attached image (NLS_LANG_Chinese.jpg)
- You need to change the character set value to ZHT16BIG5.
For example it may look like AMERICAN_AMERICA.UTF8 you need to change this to AMERICAN_AMERICA.ZHT16BIG5
- Close and Restart TOAD.
