Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

Questions
Tags
Users
Badges
Fernando Cendan
(6●4●4) 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.

0 votes

1 answer
6,726 views
0 votes

One answer

Permanent link
Ginny Ghezzo
JAZZ DEVELOPER (333●1●11●17) Apr 25 '12, 12:00 p.m.
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.

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Mar 31 '11, 5:05 a.m.

Question was seen: 6,726 times

Last updated: Mar 31 '11, 5:05 a.m.

Confirmation Cancel Confirm