Data Types

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.

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.

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.

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