Re: Win2K/Ora9iR2/Unicode

From: Michael Möller <m2_at_email.dk>
Date: Thu, 04 Mar 2004 22:21:52 +0100
Message-ID: <40479DF0.95E88531@email.dk>

The problem is with the client, not the database. There is no "unicode-terminal", so whatever you select is converted to and thus limited by the client characterset. I havent tried with iSQL*Plus .... just a mo' I'll test now.
[Windows machine, registery, set NLS_LANG to ...utf8. *then* start iSQLplus server(HTTP server).... ] Yes it displays all! (within the limits of your browser and fontset) Also the Data Editor in DBA Studio or View/Edit in OEM facilty lets you view the unicode data in all their glory.

Look at the data in OE.PRODUCT_DESCRIPTIONS, that is one of the sample/demo schemas supplied.

M-square
(Michael Möller)

"Vergara, Michael (TEM)" wrote:

> Hi All!
>
> We're experimenting with Unicode in Oracle 9i. We've experimented
> with the various NLS_LANG settings, but I cannot seem to get
> Unicode characters to display properly. I've tried SQL*Plus for
> Windows, SQL*Plus for HP-UX, and iSQL*Plus. No Joy anywhere.
>
> Has anybody fought with this before? Know any good tips or
> pointers?
>
> Thanks,
> Mike
>
> ---
> ===========================================================================
> Michael P. Vergara
> Oracle DBA
> Guidant Corporation
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Mar 04 2004 - 16:14:04 CST