Question

2
Replies
131
Views
UweG2962 Member since 2014 23 posts
Allianz Deutschland AG
Posted: 4 years ago
Last activity: 4 years 4 months ago
Closed
Solved

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:

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 11.2.0.2.0          

Regards

Uwe

Moderation Team has archived post
Share this page LinkedIn