Data Types

Data type is the classification identifying one of various types of data available for storage, display, and segmentation.

The following table defines each supported data type:

Type

Alternate Name

Description

Number

Integer

A +/- integer from -2147483648 to2147483647

This type supports numeric characters and the negative '-' symbol only.  Commas, periods or other modifiers cannot be used.  Leading 0's are also not supported and are dropped when the value is saved.

Float

A -/+ floating point integer, a number with a decimal

This type supports numeric characters, the decimal '.' and negative '-' symbol only.  Commas or other modifiers cannot be used.  Leading 0's are also not supported and are dropped when the value is saved.

String

Text, Large, Unicode

A string of characters

The type supports all valid alphanumeric, punctuation, and special characters based on the database setting (default is UTF-8).  

The string length supported depends on the feature in which it is used. 

  • Relational Database can support a string up to 4000 characters.  The size for each is defined when the field is created.

  • Custom Text and Unicode fields support up to 512 characters. 

  • Custom Large fields support up to 4000 characters. Large fields are not supported in segmentation.

Date

A date with a four digit year (yyyy).  

The type supports various formatting options depending on the feature.  All formatting options do require a four digit year, such as 1993 or 2015.

The most common formats use the dash or slash divider, and include:

  • yyyy-MM-dd HH:mm:ss

  • yyyy/MM/dd HH:mm:ss

  • yyyy.MM.dd HH:mm:ss

  • yyyy-MM-dd

  • MM-dd-yyyy HH:mm:ss

  • MM-dd-yyyy

  • MM/dd/yyyy HH:mm:ss

  • MM/dd/yyyy

  • MMMMM dd, yyyy

  • dd-MMM-yyyy