Follow

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.  For example, Relational Database can support a string up to 4000 characters.  Custom Text and Unicode fields support up to 512 characters. 

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
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk