problem displaying umlaut character

From: Jerry C <usidba_at_yahoo.com>
Date: Tue, 06 Feb 2001 09:50:14 -0800
Message-ID: <F001.002AC045.20010206070129@fatcity.com>

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'; 
 

<FONT face="Courier New"
size=2>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
 
Received on Tue Feb 06 2001 - 11:50:14 CST