Re: Seeing non-ASCII character data from SQL Plus

It usually takes some playing around. I used to be able to view CKJ (Chinese, Korean, Japanese) characters with SQL*Worksheet and a with a third party tool called NJStar running in the back ground. With iSQL*Plus, it seems to be easier. All you need to do is set the browser encoding correctly to view the characters, provided the data has been loaded into the database correctly of course.

• Jusung Yang

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
Received on Tue Oct 29 2002 - 04:40:03 CET