The information in this document applies to users accessing ExactTarget Email via the Salesforce Marketing Cloud or http://members.exacttarget.com.

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

Text

  • 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

Number

  • 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

Date

  • 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 format MM/DD/YYYY, 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.

Boolean

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

Email

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

ExactTarget checks the syntax of email address and provides an error when that syntax is incorrect. ExactTarget 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.

Phone

  • 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

Decimal

  • 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 lenght of 8,2:
    • 123456.78
    • 12345678
    • 12.34
    • 1234
    • .12
    • 12

Locale

  • 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 ccantrell at 08:34, 30 Oct 2014