Database column types used for AR System fields

This topic lists the column types used for AR System fields in each database type supported by AR System. Control, display-only, page, page holder, table, table column, trim, and view fields do not require storage in database tables, so they are not listed in this section.

Related topics

Data-management-in-the-AR-System-database

Relationship-between-forms-and-database-tables

Microsoft SQL Server column types used for AR System fields 

The following table shows the Microsoft SQL Server column types used for each AR System field type whose values are stored in database tables.

Microsoft SQL Server column types used with AR System fields

Oracle column types used for AR System  fields

Creating-a-process-administrator shows the Oracle column types used for each AR System field type whose values are stored in database tables.

Oracle column types used with AR System field types

For more information about the storage and performance effects of using in-row versus out-row CLOBs, see Evaluating-and-specifying-storage-for-Oracle-LOBs. The corresponding setting in the AR System server configuration file is Oracle-Clob-Storage-In-Row.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*