When upgrading from Toad 8.x to 9.6.1, I was able to see international characters for French and Spanish in the previous version, but not after upgrading to 9.6.1.
1. Set NLS_LANGUAGE variable in the following locations of the Registry:
- HKEY_LOCAL_MACHINE | SOFTWARE | ORACLE
- HKEY_LOCAL_MACHINE | SOFTWARE | ORACLE | KEY_OraClient10g_home1
EX: NLS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P1
(See Screen Shots: Oracle lang key.JPG and Oracle lang key 2.JPG)
2. Restart Toad
This may be a environment specific issue. Please verify all language setting for the client and OS.