Different Oracle NLS_LENGTH_SEMANTICS
Hi,
we are using one server for development and another servers, for testing, integeration and production. All installed with Pega 7.1.9 and equal HF, we are using Oracle DB and WebSphere. The stages for dev, testing and production are using NLS_LENGTH_SEMANTICS "CHAR", the stage T is using "BYTE". See attachement pyClassNameOnStageE/T.
Is it possible, that we run into problems? It seems that all VARCHAR2-Columns have different lengths?
dbVisualizer displays the following different column length:
Dev:
T:
Column informations
Dev:
T:
Hi,
we are using one server for development and another servers, for testing, integeration and production. All installed with Pega 7.1.9 and equal HF, we are using Oracle DB and WebSphere. The stages for dev, testing and production are using NLS_LENGTH_SEMANTICS "CHAR", the stage T is using "BYTE". See attachement pyClassNameOnStageE/T.
Is it possible, that we run into problems? It seems that all VARCHAR2-Columns have different lengths?
dbVisualizer displays the following different column length:
Dev:
T:
Column informations
Dev:
T:
Here are the database parameters (identical on all stages!):
PARAMETER VALUE
----------------------- ----------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
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_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION Proprietary information hidden.0
Regards
Uwe