From oracle-l-bounce@freelists.org Thu Mar 4 16:14:04 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i24ME4x10058 for ; Thu, 4 Mar 2004 16:14:04 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i24ME3o10050 for ; Thu, 4 Mar 2004 16:14:03 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CC51F396846; Thu, 4 Mar 2004 16:33:18 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 04 Mar 2004 16:32:11 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from cicero0.cybercity.dk (cicero0.cybercity.dk [212.242.40.52]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AAD25395D99 for ; Thu, 4 Mar 2004 16:19:47 -0500 (EST) Received: from user2.cybercity.dk (fxp0.user2.ip.cybercity.dk [212.242.41.35]) by cicero0.cybercity.dk (Postfix) with ESMTP id 384E128DE8 for ; Thu, 4 Mar 2004 22:23:45 +0100 (CET) Received: from email.dk (port404.ds1-brh.adsl.cybercity.dk [212.242.239.169]) by user2.cybercity.dk (Postfix) with ESMTP id 0F89718653 for ; Thu, 4 Mar 2004 22:23:45 +0100 (CET) Message-ID: <40479DF0.95E88531@email.dk> Date: Thu, 04 Mar 2004 22:21:52 +0100 From: Michael =?iso-8859-1?Q?M=F6ller?= Organization: HomeSweetHome X-Mailer: Mozilla 4.76 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: oracle-l@freelists.org Subject: Re: Win2K/Ora9iR2/Unicode References: <791D0E1ECDECD04D89205F33806FC38701E91C78@temmse06.tem.guidant.com> Content-Type: text/plain; charset=iso-8859-1 X-archive-position: 427 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: m2@email.dk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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@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@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 -----------------------------------------------------------------