3 Replies Latest reply: Nov 1, 2012 8:52 AM by Osama_Mustafa RSS

    serbian character problem

    rootsman
      Hi guys,

      I have problem with serbian characters in our database. Database version is 10.2.0.3.0 and NLS_PARAMETERS are :

      PARAMETER     VALUE
      NLS_LANGUAGE     AMERICAN
      NLS_TERRITORY     AMERICA
      NLS_CURRENCY     $
      NLS_ISO_CURRENCY     AMERICA
      NLS_NUMERIC_CHARACTERS     .,
      NLS_CALENDAR     GREGORIAN
      NLS_DATE_FORMAT     DD-MON-RR
      NLS_DATE_LANGUAGE     AMERICAN
      NLS_CHARACTERSET     EE8ISO8859P2
      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_NCHAR_CHARACTERSET     AL16UTF16
      NLS_COMP     BINARY
      NLS_LENGTH_SEMANTICS     BYTE
      NLS_NCHAR_CONV_EXCP     FALSE


      As you can see for database default language value is AMERICAN so i have tried to bypass this by executing:

      alter session set NLS_LANGUAGE = CROATIAN
      alter session set NLS_TERRITORY = CROATIA

      because value SERBIAN didnt work, but still i was unable to insert values in tables like ćčđšž and etc.

      Any suggestion?