Re: problem displaying umlaut character

[Jerry C]

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:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 10:01 AM To: Multiple recipients of list ORACLE-L Subject: 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 - Production With the Partitioning and Java options PL/SQL Release 8.1.5.0.0 - Production   SVRMGR> connect internal Connected. SVRMGR> show parameter NLS NAME                                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 125 SQL> select * from nls_database_parameters ; PARAMETER VALUE ------------------------------ -------------------------------------------------------------------------------- ---------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET UTF8 NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-YY NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM PARAMETER VALUE ------------------------------ -------------------------------------------------------------------------------- ---------- NLS_TIMESTAMP_FORMAT DD-MON-YY HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM NLS_TIMESTAMP_TZ_FORMAT DD-MON-YY HH.MI.SSXFF AM TZH:T NLS_DUAL_CURRENCY $ NLS_COMP NLS_NCHAR_CHARACTERSET UTF8 NLS_RDBMS_VERSION 8.1.5.0.0 18 rows selected. A virtual homebrew (British Pale Ale) to anybody who can help!     Thanks!   - Jerry