Asian characters encoded using US7ASCII characterset cannot be displayed correctly in TOAD. (4332226)

WORKAROUND:

Execute the query via SQL*Plus from Toad.

  

STATUS:

Dev comments that no fix will be available. Read on for more information.

  

ADDITIONAL INFORMATION:

  

Taken from Oracle [http://www.oracle.com/technetwork/database/database-technologies/globalization/nls-lang-099431.html]  #_Toc110410572

  

What is the difference between 7 bit, 8 bit and Unicode Character sets?

  

A 7 bit character set only knows 128 symbols (2^7)

An 8 bit character set knows 256 symbols (2^8)

  

Unicode (UTF-8) is a multibyte character set. Unicode has the capability to define over a million characters. For more information on Unicode see the white paperOracle Unicode Database Support.

  

How to choose the right database character set?

  

A basic consideration for choosing a character set is to make sure it can handle any language that needs to be supported immediately and in the indeterminate future. Another overlooked consideration is to think about what applications and technologies you may want to utilize or interact with the database. Use locale builder (from Oracle Database 9i onwards) to view what characters are defined for a particular Oracle character set.

  

Choosing Unicode as the database character set ensures a strong foundation for whatever is built into and on top of the database.Oracle recommends using Unicode for all new system deployment. Migrating legacy systems to Unicode is also recommended. Deploying your systems today in Unicode offers many advantages in usability, compatibility, and extensibility. Oracle's comprehensive support allows you to deploy high-performing systems faster and more easily while leveraging the true power of Unicode. Even if you don't need to support multilingual data today or have any requirement for Unicode, it is still likely to be the best choice for a new system in the long run and will ultimately save you time and money and give you competitive advantages.