Hi Gurus,

I have unicode stored in database NVARCHAR datatype column. How do I display
it in iSQLPlus?

SQL> insert into nlsdata values(1,unistr('\0061'));
1 row created.

SQL> insert into nlsdata values(1,unistr('\0B8F'));
1 row created.

SQL> select unistr(c2) from nlsdata;

UNISTR(C2)
----------------------------------------------------------------------------
----
a
??Å

SQL>

Oracle LazyDBA home page