This discussion is archived
3 Replies Latest reply: Nov 1, 2012 6:52 AM by Osama_Mustafa RSS

serbian character problem

rootsman Newbie
Currently Being Moderated
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?

Legend

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