You can select a data type from the following available choices when you create a data extension column: 


  • A combination of letters, numbers, and spaces
  • Up to 4000 characters can be accepted
  • Text field definitions can only be updated to increase the size of the field


  • An integer
  • You cannot import decimal values into a column with this data type. If you need to import decimal values, use the Decimal data type instead
  • This type accepts values from -2,147,483,648 to 2,147,483,648


  • A system date
  • You can use an AMPscript function to format this value when you present it in a message
  • Attributes of a date type will accept dates in various formats, such as 1/1/2005 or January 1, 2005
  • All dates are stored in the 12-hour format of MM/DD/YYYY HH:MM:SS, and if a date is entered in a different format, the system will convert it to the proper format when storing it
  • Valid date values begin after 12/31/1772 and before 01/01/10000
  • You can add a HH:MM time value following the date value, such as 12/12/2012 12:12 PM.


  • True Values
    • 1
    • Y
    • Yes
    • TRUE
  • False Values
    • 0
    • N
    • No
    • FALSE


  • An email address
  • A field of this type must exist in order for you to send an email to a data extension

The system checks the syntax of email address and provides an error when that syntax is incorrect. The system does not verify that the value in this field is a valid email address (whether it will actually receive an emaill message when included as part of a send) when importing data.


  • A phone number
  • This data type accepts accepts any string with 10 or 11 digits in it and strips out non-digit characters. For example, the following examples are acceptable:
    • 555-555-5555
    • 1-555-555-5555
    • 1-(555)-555-5555
    • (555)-555-5555


  • A number with a decimal point
  • When you define a field as decimal, you indicate the total maximum length of the field and how many places after the decimal the field can hold. For Length, the first field is the total maximum number of digits and the second field is the maximum number of digits after the decimal point. For example, if you define a decimal field with a length of 8,2, the total maximum number of digits the field can hold is 8 with 2 digits after the decimal point. For this scenario, you can have up to 6 digits before the decimal if you have 2 after the decimal. Or you can have a maximum of 8 digits before the decimal if you have 0 after the decimal. Examples of acceptable numbers for a length of 8,2:
    • 123456.78
    • 12345678
    • 12.34
    • 1234
    • .12
    • 12


  • An ISO language and country code
  • This field requires a minimum of two characters (to define the country of the subscriber), but it can be expanded to five characters to accommodate a language as well. For example, a resident of the United States who speaks English would receive the EN-US Locale value.
Was This Page Helpful?
Last updated by bhobbs at 09:51, 3 Nov 2015