RE: problem displaying umlaut character

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Tue, 06 Feb 2001 12:07:40 -0800
Message-ID: <F001.002AC532.20010206100212@fatcity.com>

NLS to
WesternEuropean.

  <FONT face="Times New Roman"
  size=2>-----Original Message-----From: Jerry C   [mailto:usidba_at_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'; 
 

  <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 - 14:07:40 CST