|
Jerry,
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:
select
dump(col1) from umlaut where col1='Br�mmel';
Check the ascii value of the 3rd char to see it it is a v or an
�
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.
If you post the answers to these questions, I'll try to
earn my virtual homebrew!
Gary Kirsh
Next Extent, Inc
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';
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 - Production
With the Partitioning and
Java options
PL/SQL Release 8.1.5.0.0 - Production
SVRMGR>
connect internal
Connected.
SVRMGR> show parameter
NLS
NAME
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 125
SQL>
select * from nls_database_parameters ;
PARAMETER
VALUE
------------------------------
--------------------------------------------------------------------------------
----------
NLS_LANGUAGE
AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY
AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET UTF8
NLS_CALENDAR
GREGORIAN
NLS_DATE_FORMAT DD-MON-YY
NLS_DATE_LANGUAGE
AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
PARAMETER
VALUE
------------------------------
--------------------------------------------------------------------------------
----------
NLS_TIMESTAMP_FORMAT
DD-MON-YY HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM
TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-YY HH.MI.SSXFF AM
TZH:T
NLS_DUAL_CURRENCY $
NLS_COMP
NLS_NCHAR_CHARACTERSET
UTF8
NLS_RDBMS_VERSION 8.1.5.0.0
18 rows selected.
A
virtual homebrew (British Pale Ale) to anybody who can help!
Thanks!
- Jerry
| 