Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

german Umlaut problem (NLS_LANGUAGE or Charachter set ?)

468116Oct 13 2006 — edited Nov 8 2006

I have problem with umlaut german character (ö,ä,ü,Ö,Ä;Ü) they showed as ?
Can any body help me?
Character set is correct () I change NLS_LANGUAGE of session to GERMAN but problem remain.

here is result of quering sys.props$:

DICT.BASE 2
DEFAULT_TEMP_TABLESPACE TEMP
DBTIMEZONE -07:00
NLS_NCHAR_CHARACTERSET AL16UTF16
GLOBAL_DB_NAME xxxxx
EXPORT_VIEWS_VERSION 8
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8ISO8859P1
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_RDBMS_VERSION 9.2.0.8.0

Message was edited by:
reza rawassizadeh

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 6 2006

Added on Oct 13 2006

#database-key-features, #globalization-support

11 comments

15,303 views