And the session ones ?: nls_session_parameters. Derivated from init.ora
settings and NLS_LANG environment variable on Unix or NLS_LANG field of
regedit on Windows.
Regards.
> -----Mensaje original-----
> De: Jerry C [SMTP:[EMAIL PROTECTED]]
> Enviado el: martes 6 de febrero de 2001 16:01
> Para: Multiple recipients of list ORACLE-L
> Asunto: 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';
>
> 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
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Trassens, Christian
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
