| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: problem displaying umlaut character
<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
MM/DD/RRRR nls_date_language string nls_dual_currency string nls_iso_currency string nls_language
AMERICAN nls_numeric_characters string nls_sort string nls_territory
AMERICA nls_time_format string nls_time_tz_format string nls_timestamp_format stringnls_timestamp_tz_format
string
SQL> set linesize 125SQL>
select * from nls_database_parameters ;PARAMETER
VALUE------------------------------ ------------------------------------------------------------------------------------------NLS_LANGUAGEAMERICANNLS_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_FORMATDD-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!
 |
 |