Database column types used for AR System fields
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
PostgreSQL Server column types used for AR System fields
The following table shows the PostgreSQL Server column types used for each AR System field type whose values are stored in database tables.
PostgreSQL Server column types used with AR System fields
| AR System field type | PostgreSQL column type |
| Attachment up to 1 GB (PostgreSQL does not allow storing more than 1 GB) | BYTEA |
| Character with a maximum length of 4000 or fewer bytes | CITEXT (for case insensitive) VARCHAR (for case sensitive) |
| Character with an unlimited length or a maximum length of more than 4000 bytes | CITEXT (for case insensitive) TEXT (for case sensitive) |
| Currency (a group of columns composed of a combination of the specified column types) | BIGINT, CITEXT / VARCHAR, and NUMERIC (28,10) |
| Date | INTEGER |
| Date/Time (time stamp) | INTEGER |
| Decimal | NUMERIC (28,10) |
| Diary | CITEXT / TEXT |
| Integer | INTEGER |
| Real | DOUBLE PRECISION |
| Selection | INTEGER |
| Time | INTEGER |
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.