In this global economy the need for software globalization is increasing. As a result of this globalization, localization is becoming an important part of software development. And as a result of this localization, software developers like myself will have to work with multiple languages. So, it is becoming more crucial to have development tools that support multi-byte in addition to single-byte characters, like Chinese versus English for example.
As an Oracle database developer I have been using Quest Software Inc.’s SQL Navigator for years. We are currently involved in the implementation of Oracle E-Business Suite in our new plant in China. So, now we have the Chinese characters to worry about. It turns out that SQL Navigator does not support multi-byte characters and UTF8 encoding (which is needed to display Chinese characters), however, Oracle’s SQL developer does
Here is how SQL Navigator displays a query result that returns Chinese characters:
And here is the same query in SQL developer:
SQL Navigator developers are going to include UTF8 support in the next release (5.5) which should be out by the end of summer.
Does TOAD support UTF8? Just curious.
Thanks to Braj, I was able to make SQL Navigator display Chinese characters. Here’s what you have to do (on Win XP):
Now, you need to set the NLS_LANG environment variable. Here is how you do it:
You should see “real” Chinese characters in the query result. Of course, you will have to know Chinese to read the query result
To revert back to English (or whatever language you had before), just undo what you did in the steps above.