Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: problem displaying umlaut character

RE: problem displaying umlaut character

From: Kirsh, Gary <gary.kirsh_at_gs.com>
Date: Tue, 06 Feb 2001 11:46:55 -0800
Message-ID: <F001.002AC651.20010206102138@fatcity.com>

<FONT face=Arial color=#0000ff

size=2>Jerry,
<FONT face=Arial color=#0000ff

size=2> 
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:
<FONT face=Arial color=#0000ff

size=2> 
select
dump(col1) from umlaut where col1='Brömmel'; 
<FONT face="Courier New"

size=2> 
<FONT

color=#0000ff>Check the ascii value of the 3rd char to see it it is a v or an ö<FONT
color=#000000>  
<SPAN

class=280140718-06022001>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.
<SPAN

class=280140718-06022001> 
<SPAN

class=280140718-06022001>If you post the answers to these questions, I'll try to earn my virtual homebrew!
<SPAN

class=280140718-06022001> 
<SPAN

class=280140718-06022001>Gary Kirsh
<SPAN

class=280140718-06022001>Next Extent, Inc
<FONT face="Courier New" color=#0000ff

size=2> 
<FONT face="Courier New" color=#0000ff

size=2> 

  <FONT face=Tahoma
  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!
    Received on Tue Feb 06 2001 - 13:46:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US