Data types

When adding source queries to your integrations, use the following information to help you select the most appropriate data type.

Data type

 

 

Boolean

Destination Object Type

Boolean

Acceptable Data types

Boolean, Byte, Integer, String

Preferred Data type

Boolean

Additional information

If using Boolean as the data type, the following values are Acceptable as true or false:

TrueFalseTrueFalse

TFYN
tfyn
TrueFalseYesNo
TRUEFALSEYESNO
10Non-zero0

Currency

Destination Object Type

Currency

Acceptable Data types

Currency, Double, Single, String

Preferred data type

Currency

Additional information

If the currency data in the text file is formatted, for example, if it has a dollar sign ($), you must use a Currency data type.

 

If the currency data in the text file has more than six significant digits, do not use the Single data type. If the currency data has more than 14 significant digits, do not use the Double data type. Instead, use the Currency or String Data types.

 

If the currency values in the text file have more than four decimal places, you must use the String data type.

Date

Destination Object Type

Date

Acceptable Data types

Date, String

Preferred data type

Date

Additional information

If you are using date information to restrict the source, you must use the Date data type.

 

The acceptable formats for date values are based on the date settings in the Windows Regional Settings control panel.

The following examples assume that you have specified a standard U.S. date format in the Regional Settings control panel.

 

If you use the Date data type, the data in the column must be in one of the following formats:

9–25–98

9–25–1998

9/25/98

9/25/1998

SEP–25–98

 

If you use the String data type, the data in the column can be in any of the following formats:

9–25–98

25–9–98

9/25/98

25/9/98

SEP–25–98

25–SEP–98

September 25, 1998

25 September 1998

1998–9–25

1998–SEP–25

 

Other formats may work as well.

Enumeration

Destination Object Type

Enumeration

Acceptable Data types

Integer, String

Preferred data type

Integer

Integer

Destination Object Type

Integer

Acceptable Data types

Integer, String

Preferred data type

Integer

Long integer

Destination Object Type

Long integer

Acceptable Data types

Long integer, String

Preferred data type

Long integer

Numeric

Destination Object Type

Numeric

Acceptable Data types

Currency, Double, Integer, Long integer, Single, String

Preferred data type

String

Additional information

If the numeric data in the text file has more than 6 significant digits, do not use the Single data type. If the data has more than 14 significant digits, do not use the Double data type. Instead, use the Currency or String data types.

 

If the numeric values in the text file have more than four decimal places, you must use the String data type.

String

Destination Object Type

String

Acceptable Data types

String

Preferred data type

String

Additional information

If the string is over 255 characters long, you must use the LongVarChar data type.

 

If the total length of the items in the source is over the allowed limit of 2048 bytes, you can reduce the size by using a LongVarChar data type instead of a String data type.

Time

Destination Object Type

Time

Acceptable Data types

String

Preferred data type

String

Additional information

Time values must have the form HH:MM:SS and be in 24-hour format.

 


Documentation Feedback