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!

serbian character problem

rootsmanNov 1 2012 — edited Nov 1 2012

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?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 29 2012

Added on Nov 1 2012

#database-key-features, #globalization-support

3 comments

560 views