3 Replies Latest reply: Feb 11, 2013 8:30 AM by Srini Chavali-Oracle RSS

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

    989715
      Hi,

      I am facing an issue as below.

      I have a procedure which in turn collects data from another oracle database via dblink and send the output back through out parameter.

      declare
      l_cust_type remotedb.cust_table@otherdb := remotedb.cust_table@otherdb();
      begin
      remotedb.get_cust_details@otherdb
      (p_cust_code => 1000 ----------in parameter
      ,cust_details => l_cust_type --out parameter collection
      );
      ----
      dbms_output.put_line ( .... )
      ----
      end;

      when checked the output in later database it's 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.