AnsweredAssumed Answered

Problems with international characters

Question asked by mcanovas on Feb 21, 2013
Latest reply on Feb 22, 2013 by mcanovas
Hello friends,

we are having problems after upgrade Clarity Version from 13.0.5 to 13.1.

Following to the installation manual, in the upgrade we have updated:
- jdk1.6.0_20 to jdk1.7.0_4
- Apache-tomcat 6.0.26 to Apache Tomcat 7.0.26

The installation of the the new versión has been succesfully without errors.

The probem that we have is when we try to create a new inversion instance with accents (For example: Idea test áéíóú) then when we save the inversion shows Idea test áéíóú.

We have set the NLS_LANG=AMERICAN_AMERICA.UTF8 and in JVM we added the following parameters: -Duser.country=US -Duser.language=en

The NLS Paremeters of the database are:
PARAMETER
VALUE
TIPO
NLS_NCHAR_CHARACTERSET
UTF8
nls_database_parameters
NLS_ISO_CURRENCY
AMERICA
nls_database_parameters
NLS_TIME_TZ_FORMAT
HH24:MI:SS TZR
nls_database_parameters
NLS_LENGTH_SEMANTICS
BYTE
nls_database_parameters
NLS_CURRENCY
$
nls_database_parameters
NLS_NUMERIC_CHARACTERS
.,
nls_database_parameters
NLS_LANGUAGE
AMERICAN
nls_database_parameters
NLS_RDBMS_VERSION
11.2.0.2.0
nls_database_parameters
NLS_TIME_FORMAT
HH24:MI:SS
nls_database_parameters
NLS_TIMESTAMP_TZ_FORMAT
YYYY-MM-DD HH24:MI:SS TZR
nls_database_parameters
NLS_CHARACTERSET
AL32UTF8
nls_database_parameters
NLS_DATE_FORMAT
YYYY-MM-DD HH24:MI:SS
nls_database_parameters
NLS_TIMESTAMP_FORMAT
YYYY-MM-DD HH24:MI:SS
nls_database_parameters
NLS_DATE_LANGUAGE
AMERICAN
nls_database_parameters
NLS_TERRITORY
AMERICA
nls_database_parameters
NLS_COMP
BINARY
nls_database_parameters
NLS_DUAL_CURRENCY
$
nls_database_parameters
NLS_CALENDAR
GREGORIAN
nls_database_parameters
NLS_SORT
BINARY
nls_database_parameters
NLS_NCHAR_CONV_EXCP
FALSE
nls_database_parameters
NLS_LENGTH_SEMANTICS
BYTE
nls_instance_parameters
NLS_LANGUAGE
SPANISH
nls_instance_parameters
NLS_ISO_CURRENCY
SPAIN
nls_instance_parameters
NLS_DUAL_CURRENCY
€
nls_instance_parameters
NLS_DATE_LANGUAGE
SPANISH
nls_instance_parameters
NLS_DATE_FORMAT
DD/MM/RR
nls_instance_parameters
NLS_CURRENCY
€
nls_instance_parameters
NLS_COMP
BINARY
nls_instance_parameters
NLS_TIME_TZ_FORMAT
HH24:MI:SSXFF TZR
nls_instance_parameters
NLS_CALENDAR
GREGORIAN
nls_instance_parameters
NLS_TIME_FORMAT
HH24:MI:SSXFF
nls_instance_parameters
NLS_TIMESTAMP_TZ_FORMAT
DD/MM/RR HH24:MI:SSXFF TZR
nls_instance_parameters
NLS_TIMESTAMP_FORMAT
DD/MM/RR HH24:MI:SSXFF
nls_instance_parameters
NLS_TERRITORY
SPAIN
nls_instance_parameters
NLS_SORT
SPANISH
nls_instance_parameters
NLS_NUMERIC_CHARACTERS
,.
nls_instance_parameters
NLS_NCHAR_CONV_EXCP
FALSE
nls_instance_parameters
NLS_SORT
BINARY
nls_session_parameters
NLS_LENGTH_SEMANTICS
BYTE
nls_session_parameters
NLS_DATE_LANGUAGE
AMERICAN
nls_session_parameters
NLS_TERRITORY
AMERICA
nls_session_parameters
NLS_TIME_FORMAT
HH24:MI:SS
nls_session_parameters
NLS_TIME_TZ_FORMAT
HH24:MI:SS TZR
nls_session_parameters
NLS_DATE_FORMAT
YYYY-MM-DD HH24:MI:SS
nls_session_parameters
NLS_TIMESTAMP_FORMAT
YYYY-MM-DD HH24:MI:SS
nls_session_parameters
NLS_CALENDAR

nls_session_parameters
NLS_DUAL_CURRENCY

nls_session_parameters
NLS_ISO_CURRENCY

nls_session_parameters
NLS_NUMERIC_CHARACTERS

nls_session_parameters
NLS_LANGUAGE
AMERICAN
nls_session_parameters
NLS_TIMESTAMP_TZ_FORMAT
YYYY-MM-DD HH24:MI:SS TZR
nls_session_parameters
NLS_NCHAR_CONV_EXCP
FALSE
nls_session_parameters
NLS_CURRENCY

nls_session_parameters
NLS_COMP
BINARY
nls_session_parameters
Thank you very much.

Regards.

Outcomes