Oracle Charset, is it mandatory UTF-8?, Spanish settings?
![]()
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
![]()
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 |
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.