enum ODBPP::DataType

NameWindows 32bitLinux 32bitLengthValueDescription
BOOLboolbool12boolean
CHAR8charchar158-bit character
CHAR16char16_tchar16_t2716-bit wide character
INT8charchar198-bit signed integer
UINT8unsigned charunsigned char1118-bit unsigned integer
INT16shortshort21316-bit signed integer
UINT16unsigned shortunsigned short21516-bit unsigned integer
INT32intlong41732-bit signed integer
UINT32unsigned intunsigned long41932-bit unsigned integer
INT64__int64long long int82164-bit signed integer
UINT64unsigned __int64unsigned long long int82364-bit unsigned integer
FLOAT32floatfloat42532-bit floating point
FLOAT64doubledouble82764-bit floating point
DATEn/an/a43132-bit day counter from 1/1/1601
unsigned __int64 filetime = (date * 864000000000) + 432000000000;
FILETIMEFILETIMEtypedef struct {
   unsigned int dwLowDateTime;
   unsigned int dwHighDateTime;
} FILETIME;
83364-bit 100-nanosecond (10x-7) counter from 1/1/1601
OBJECTIDunsigned intunsigned int43532-bit unsigned integer object identifier pointer
OBJECTID64__int64long long int84364-bit integer object identifier pointer, added Version 3.0
ARRAYBYTE[]unsigned char[]n/a378-bit character array for general use - indexable
RECTRECTtypedef struct {
   int left;
   int top;
   int right;
   int bottom;
} RECT;
1639rectangle - indexable (Spatial Index only)
CUBEtypedef struct {
   int left;
   int top;
   int front;
   int right;
   int bottom;
   int rear;
} CUBE;
typedef struct {
   int left;
   int top;
   int front;
   int right;
   int bottom;
   int rear;
} CUBE;
2441cube - indexable (Spatial Index only).
Left - specifies the x-coordinate of the upper-left corner of the rectangle. Top - specifies the y-coordinate of the upper-left corner of the rectangle. Front - specifies the z-coordinate of the upper-left corner of the rectangle. Right - specifies the x-coordinate of the lower-right corner of the rectangle Bottom - specifies the y-coordinate of the lower-right corner of the rectangle. Rear - specifies the z-coordinate of the lower-right corner of the rectangle.
ASTRBYTE[]unsigned char[]n/a2UTF-8 character string - null terminating
USTRchar16_t[]char16_t[]n/a4UTF-16 wide character string - null terminating
SBSTRn/an/an/a6short binary string, first 2 bytes have the length of the SBSTR including the 2 bytes - non-indexable
BSTRn/an/an/a8binary string, first 4 bytes have the length of the BSTR including the 4 bytes - non-indexable
PATTERN2Dn/an/an/a12binary string, first 4 bytes have the length of the 2-D pattern including the 4 bytes, string containing POINT tuples {x,y}, added Version 4.1 - indexable with Pattern indexes
PATTERN3Dn/an/an/a14binary string, first 4 bytes have the length of the 3-D pattern including the 4 bytes, string containing POINT3D tuples {x,y,z}, added Version 4.1 - indexable with Pattern indexes
SUB_TABLEn/an/an/a10binary string that contains sub-table objects - this field is non-indexable, but the sub-fields within this are indexable (Version 2.1 and on)