E-ORA: DDL Generated For Unicode Oracle Databases Triples the Character Length Of Fields Specified In Application Designer (Doc ID 1239583.1)

Last updated on JULY 18, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version: 8.18 to 8.51 - Release: 8.1 to 8.4
Information in this document applies to any platform.

Goal

For PeopleTools Unicode Databases, when creating a record with character field of length 8 in Application Designer, the DDL script generated shows the length as 24 "VARCHAR(24)".   It tripled the length as defined in Application Designer.  Why/when does this occur?


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms