Supported Data Types
The following table contains the valid data types supported by the 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.
TypeName | Support | Storage Data Types for SQL (Data Warehouse only) | Description |
---|---|---|---|
BINARY | Profiling System | varbinary | Binary |
BOOL | Both | bit | Boolean (0 or 1) |
CURRENCY | Both | money | 64-bit currency |
DATE | Both | datetime | Standard date |
DATETIME | Both | datetime | SQL Date-time |
FILETIME | Data Warehouse | datetime | Standard file date/time stamp |
FLOAT | Profiling System | float | 4-byte floating point number |
IDENTITY | Data Warehouse | binary(6) | 48-bit numerical identifier
Does not support multi-valued members |
IDENTITY6 | Data Warehouse | binary(6) | 48-bit numerical identifier
Does not support multi-valued members |
IMAGE | Profiling System | varbinary | limit 8,000 bytes |
INT64 | Data Warehouse | bigint | 64-bit integer
Does not support multi-valued members |
LONG | Data Warehouse | int | 32-bit integer |
LONGREAL | Data Warehouse | float(53) | 64-bit floating point number |
LONGTEXT | Profiling System | text | Unicode string of length 4000 characters |
NUMBER | Profiling System | int | 4-byte integer |
REAL | Data Warehouse | real | 32-bit floating point number |
SHORT | Data Warehouse | smallint | 16-bit integer |
STRING | Profiling System | nvarchar | Standard string |
TIME | Profiling System | datetime | Standard time |
UINT64 | Profiling System | bigint | 64-bit unsigned integer
Does not support multi-valued members |
ULONG | Data Warehouse | int | 32-bit unsigned integer
Does not support multi-valued members |
UUID | Data Warehouse | uniqueidentifier | Packed decimal number used for globally unique identifiers (GUID) |
WORD | Data Warehouse | smallint | 16-bit unsigned integer
Does not support multi-valued members |
WSTR | Data Warehouse | nvarchar (255) | Unicode string of length 255 |
WSTR8, WSTR12. WSTR16, WSTR24, WSTR32, WSTR48, WSTR64, WSTR80, WSTR96, WSTR112, WSTR128, WSTR144, WSTR160, WSTR255, WSTR400, WSTR512 | Data Warehouse | nvarchar | Unicode string of designated length, WSTR8 is nvarchar (8), WSTR12 is nvarchar (12), and so on |
WSTR1K, WSTR2K, WSTR4K | Profiling System | nvarchar | Unicode string of designated length, WSTR1K is nvarchar (1000), WSTR2K is nvarchar (2000), and so on |
The following figure contains the supported conversion types for consumer-requested data.
Copyright © 2005 Microsoft Corporation.
All rights reserved.