Data types
- Last UpdatedJan 04, 2023
- 1 minute read
- PI System
- PI SQL Client OLEDB 2021
- Developer
PI SQL Client OLEDB supports the following data types:
|
Name |
Data Type Indicator |
|---|---|
|
AnsiString |
DBTYPE_STR |
|
AnsiStringCs |
DBTYPE_STR |
|
Boolean |
DBTYPE_BOOL |
|
DateTime |
DBTYPE_DBTIMESTAMP |
|
Double |
DBTYPE_R8 |
|
Guid |
DBTYPE_GUID |
|
Int8 |
DBTYPE_I1 |
|
Int16 |
DBTYPE_I2 |
|
Int32 |
DBTYPE_I4 |
|
Int64 |
DBTYPE_I8 |
|
Single |
DBTYPE_R4 |
|
String |
DBTYPE_WSTR |
|
StringCs |
DBTYPE_WSTR |
|
TimeSpan |
DBTYPE_TIME |
|
UInt8 |
DBTYPE_UI1 |
|
UInt16 |
DBTYPE_UI2 |
|
UInt32 |
DBTYPE_UI4 |
|
UInt64 |
DBTYPE_UI8 |
|
Variant |
DBTYPE_VARIANT |