Re: problem displaying umlaut character

From: Jerry C <usidba_at_yahoo.com>
Date: Wed, 07 Feb 2001 10:55:04 -0800
Message-ID: <F001.002ADB4C.20010207072548@fatcity.com>

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:  
<FONT face="Courier New"

size=2>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                       

<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message -----
  <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Kirsh, Gary

  To: <A href="mailto:ORACLE-L_at_fatcity.com"   title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L   Sent: Tuesday, February 06, 2001 1:21   PM
  Subject: RE: problem displaying umlaut   character   

<FONT color=#0000ff face=Arial

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

  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 color=#0000ff face=Arial

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

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

  size=2>If you post the answers to these   questions, I'll try to earn my virtual homebrew!
<FONT color=#0000ff face=Arial

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

  size=2>Gary Kirsh
<FONT color=#0000ff face=Arial

  size=2>Next Extent,
  Inc
<FONT color=#0000ff face="Courier New"
  size=2> 
<FONT color=#0000ff face="Courier New"
  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!
     

• Jerry  

Received on Wed Feb 07 2001 - 12:55:04 CST