Data

The following topics describe the supported data types and their formats.

• DateTime Format

• Strings

• Supported Data Types

DateTime Format

ActiveX Data Objects (ADO), OLE DB, and Open Database Connectivity (ODBC) applications should use the following escape clauses when specifying dates for input to INSERT and UPDATE statements. Use the 24-hour time format; do not use A.M or P.M to indicate morning or evening.

• {ts 'YYYY-MM-DD [HH:MM:SS.FFF]'}, for example, {ts '2000-10-31 23:59:59.999'}

• {d 'YYYY-MM-DD'}, for example, {d '2000-10-31'}

• {t 'HH:MM:SS'} for example, {t '23:59:59'}

For further information, see Writing International Transact-SQL Statements in SQL Books Online.

On import, if one member of a multi-valued DateTime member is invalid, none of the DateTime members are imported.

Strings

The Commerce database supports strings of 4000 characters. Since the Data Warehouse only supports strings of 512 characters, any string consisting of more than 512 characters will be truncated to 512 characters when it is imported.

For multi-valued strings, the count includes one additional character (the semi-colon) per element, the length of the integer specifying the number of elements, plus one.

Supported Data Types

The following table contains the valid data types supported by OLE DB Provider for Commerce Server. The Support column specifies whether the data type is supported by the Data Warehouse, the Profiling System, or both. Binary data is not supported by the Data Warehouse, but is supported by the Profiling System in the following contexts:

• Access by means of a ProfileService object or a Recordset object.

• Modification by means of a ProfileService object or a Record object.

All rights reserved.