Database data types for view forms
Unicode servers support nchar, nvarchar, or ntext data types, while non-unicode servers support char, varchar, and text data types.
SQL Server data type mappings for view forms
The following data types are supported for view forms based on a Microsoft SQL Server database table:
Microsoft SQL Server data types | AR System field types |
|---|---|
nchar,char, varchar | Character (limited length) |
ntext,text | Character (unlimited length) |
int, tinyint, smallint | Integer, Date, Date/Time |
real, float | Real |
decimal | Decimal |
datetime, smalldatetime | Date/Time (default), Date, Time |
image | Attachment field in attachment pool |
Oracle data type mappings for view forms
The following data types are supported for view forms based on an Oracle database table:
Oracle data types | AR System field types |
|---|---|
varchar, varchar2, char, nchar | Character (limited length) |
character large object (clob) | Character (unlimited length) |
number | Integer, Date, Date/Time |
float | Real |
number | Decimal |
date | Date/Time (default), Date, Time |
binary large object (blob) | Attachment field in attachment pool |