Default language.

Database data types for view forms

The following sections list the data types supported by each database for BMC Remedy AR System field types in view forms. Developer Studio automatically maps the field types to corresponding data types.

In this topic:

View forms support additional data types. This includes blobs (Oracle) and images (Microsoft SQL Server), which map to an attachment field, and several date and time data types, which map to the Date, Time, or Date/Time field types as shown in this section. (For view forms created in previous releases of AR System, Date/Time fields that were mapped to an integer column are still supported.)

In some cases, you can map a different field type to a column type if appropriate for the data. See Mapping an alternative AR System field type.

Note

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.

For information about the database column types used for AR System fields in regular forms, see Database-column-types-used-for-AR-System-fields.

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:


Oracle data type mappings for view forms

The following data types are supported for view forms based on an Oracle database table:


 

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