Re: Seeing non-ASCII character data from SQL Plus

michael.scott_at_kalido.com (Michael Scott) wrote in message news:<7ef33999.0210281010.396d2400_at_posting.google.com>...
> Hi
>
> I've got an Oracle 9.2.0 database setup with UTF8 as the database
> character set. I've managed to get some japanese character data into
> one of our tables which uses an nvarchar2 column datatype; I've also
> managed to create a table whose name includes japanese characters.
> This I've done using a custom-built C++ application which has been
> specifically built to handle Unicode character data and uses the OCI
> in Unicode-mode. What I want to be able to do is see this
> extended-character set data via another tool.
>
> So, my question is: how do I configure either SQL plus or SQL Plus
> worksheet to see this character data correctly formatted? Enterprise
> manager will show me the japanese table name correctly, but what about
> seeing the japanese characters from a select statement via SQL plus?
> All I get at present is junk data when I select from the table
> containing the japanese text data. Are these tools (and TOAD is no
> better) fundamentally not capable of displaying multi-byte character
> sets? Is there a better tool for this kind of thing?
>
> Thanks
> Michael

Basically 3 things are needed
1 Your NLS_LANG set appropiately
2 Your current Windows code page should be capable of displaying the characters
3 You should add a new key
sqlplus_font
to the registry.
The value of this variable is just any character set name known to display the characters.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Tue Oct 29 2002 - 11:09:30 CET