You may notice that text fields have different
DATA_TYPE (field type) on the database level such as
NVARCHAR2 in the example below.
This article explains the reason why there are different field types present in the database and if this behavior can be changed.
Why does this happen?
These different data types are a result of the field length change although there are a small few DB fields that will have these field types by default. Moreover, the
NVARCHAR datatype can even be changed to
NVARCHAR(MAX) to extend the field length.
As for the
NCLOB datatype, please note these are used to store large blocks of character data from the National Character Set, which can also be a consequence of the field length change in text fields.
Can this behavior be changed?
This change is not done by the Oracle database itself. Instead, it's triggered and performed by ACRM modules However, there is currently no way to customize/control this behavior when changing the field length. If you would like to have control/customization of the datatype changes in ACRM, you can submit a Feature Enhancement Request.