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