From usidba@yahoo.com Wed, 07 Feb 2001 10:55:04 -0800 From: "Jerry C" Date: Wed, 07 Feb 2001 10:55:04 -0800 Subject: Re: problem displaying umlaut character Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi Gary and all,   Thank you very much for the replies. Setting the environment variable NLS_LANG=AMERICAN_AMERICA.UTF8 solved the problem.   I'm still a little confused as to how all this NLS stuff works, though. In the database, we had:   nls_language                        string  AMERICAN                      nls_territory                       string  AMERICA   and   NLS_CHARACTERSET UTF8 But I still had to set the environment variable to store and display the umlaut correctly. Hmmmmmm....     Thanks again for your help! The virtual British Pale Ale (homebrewed) will be heading your way over the ether - no spilling!     - Jerry                      
----- Original Message -----
From: Kirsh, Gary To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 06, 2001 1:21 PM Subject: RE: problem displaying umlaut character Jerry,   When debugging this type of problem, you need to determine if the umlaut character is being stored incorrectly in the database, or just displayed incorrectly when you select it.  Use the DUMP function to see the internal representation of the character:   select dump(col1) from umlaut where col1='Brömmel';    Check the ascii value of the 3rd char to see it it is a v or an ö   Also, what is the value of NLS_LANG on the client?  Is it AMERICAN_AMERICA.UTF8?  What is the client?  Are you on the server, or connecting over sqlnet?  If you are running from a DOS client, you may need to change the code page to display the character correctly.   If you post the answers to these questions, I'll try to earn my virtual homebrew!   Gary Kirsh Next Extent, Inc     -----Original Message-----From: Jerry C [mailto:usidba@yahoo.com]Sent: Tuesday, February 06, 2001 10:01 AMTo: Multiple recipients of list ORACLE-LSubject: problem displaying umlaut character Hi all,   I'm having problems displaying an umlaut character correctly. For example: create table umlaut(col1 varchar2(10));  Table created.   insert into umlaut values('Brömmel'); 1 row created. select * from umlaut where col1='Brömmel';    COL1----------Brvmmel    My NLS parameters:   msuawo01> svrmgrl Oracle Server Manager Release 3.1.5.0.0 - Production (c) Copyright 1997, Oracle Corporation.  All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.5.0.0 - ProductionWith the Partitioning and Java optionsPL/SQL Release 8.1.5.0.0 - Production SVRMGR> connect internalConnected.SVRMGR> show parameter NLSNAME                                TYPE    VALUE----------------------------------- ------- ------------------------------nls_calendar                        string                                nls_comp                            string                                nls_currency                        string                                nls_date_format                     string  MM/DD/RRRR                    nls_date_language                   string                                nls_dual_currency                   string                                nls_iso_currency                    string                                nls_language                        string  AMERICAN                      nls_numeric_characters              string                                nls_sort                            string                                nls_territory                       string  AMERICA                       nls_time_format                     string                                nls_time_tz_format                  string                                nls_timestamp_format                string                                nls_timestamp_tz_format             string                                  SQL> set linesize 125SQL> select * from nls_database_parameters ;PARAMETER VALUE------------------------------ ------------------------------------------------------------------------------------------NLS_LANGUAGE AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY AMERICANLS_NUMERIC_CHARACTERS .,NLS_CHARACTERSET UTF8NLS_CALENDAR GREGORIANNLS_DATE_FORMAT DD-MON-YYNLS_DATE_LANGUAGE AMERICANNLS_SORT BINARYNLS_TIME_FORMAT HH.MI.SSXFF AMPARAMETER VALUE------------------------------ ------------------------------------------------------------------------------------------NLS_TIMESTAMP_FORMAT DD-MON-YY HH.MI.SSXFF AMNLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZMNLS_TIMESTAMP_TZ_FORMAT DD-MON-YY HH.MI.SSXFF AM TZH:TNLS_DUAL_CURRENCY $NLS_COMPNLS_NCHAR_CHARACTERSET UTF8NLS_RDBMS_VERSION 8.1.5.0.018 rows selected.A virtual homebrew (British Pale Ale) to anybody who can help!     Thanks!   - Jerry