It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787

question asked: Mar 31 '11, 5:05 a.m.
question was seen: 6,193 times
last updated: Mar 31 '11, 5:05 a.m.

Related questions

FAQ - How this Forum works

Oracle Charset, is it mandatory UTF-8?, Spanish settings?

0
Fernando Cendan (6●4●4) | asked Mar 31 '11, 5:05 a.m.
Hi

We are tryin to install RTC 3, using Oracle as database, our DBAs ask us to use other default charset.
Our spanish Oracle default installation has this default configuration values:

NLS_CHARACTERSET WE8ISO8859P1
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD/MM/RR
NLS_DATE_LANGUAGE SPANISH
NLS_SORT SPANISH
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD/MM/RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT DD/MM/RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY ?
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 11.1.0.7.0

Is it posible use AL16UTF16 instead of UTF-8 in RTC?
CREATE DATABASE JTS USER SYS IDENTIFIED BY <system> CHARACTER SET UTF-8;

Can we have problems with any other configuration setting?

Thanks in advance.

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Ginny Ghezzo (333●1●11●17) | answered Apr 25 '12, 12:00 p.m.
JAZZ DEVELOPER
The recommendation is to use UTF-8 as documented in the infocenter. We have seen issues when other character sets are used.
Thanks,
Ginny

Hi

We are tryin to install RTC 3, using Oracle as database, our DBAs ask us to use other default charset.
Our spanish Oracle default installation has this default configuration values:

NLS_CHARACTERSET WE8ISO8859P1
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD/MM/RR
NLS_DATE_LANGUAGE SPANISH
NLS_SORT SPANISH
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD/MM/RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT DD/MM/RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY ?
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 11.1.0.7.0

Is it posible use AL16UTF16 instead of UTF-8 in RTC?
CREATE DATABASE JTS USER SYS IDENTIFIED BY <system> CHARACTER SET UTF-8;

Can we have problems with any other configuration setting?

Thanks in advance.

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.