Default language.

Database data types for view forms


This topics lists the data types that each database supports for  field types in view forms.  automatically maps the field types to corresponding data types.

View forms support additional data types, including blobs (Oracle) and images (Microsoft SQL Server), which map to an attachment field. View forms all support several date and time data types, which map to the Date, Time, or Date/Time field types. 

In some cases, you can map a different field type to a column type if appropriate for the data. See Creating-and-modifying-view-forms.

Related topics

Database-column-types-used-for-AR-System-fields

When the data types nchar, nvarchar, or ntext are supported, they are used on Unicode servers, and the char, varchar, and text data types are used on non-Unicode servers. 

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)

clob

Character (unlimited length)

number

Integer, Date, Date/Time

float

Real

number

Decimal

date

Date/Time (default), Date, Time

blob

Attachment field in attachment pool

 

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