problem displaying umlaut character

[Jerry C]

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