This discussion is archived
2 Replies Latest reply: Feb 8, 2013 1:25 AM by 989715 RSS

Diacritic (special) charcters issue eg: Australië shown as Australië

989715 Newbie
Currently Being Moderated
Hi,

I am facing an issue as below.

I have a procedure which in turn collects data from another database via dblink and send the output back through out parameter.
when checked the output in later database it showing correct,but when checked in my database it's convered and shown as below.
eg: België instead of België
Australië instead of Australië
Groot-Brittanië instead of Groot-Brittanië

select * from nls_database_parameters

PARAMETER VALUE
------------------------------------------------------------------
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8ISO8859P15
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MM-RRRR
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 11.2.0.3.0

please let me know your valuable suggestion to resolve this issue

Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points