OPC UA and ODBC database data types
FactoryTalk Optix data type | Microsoft® SQL Server data type | MySQL data type | Data type returned by a queried SQL database |
---|---|---|---|
Boolean | BIT | BIT(1) | Boolean |
Integer | BIGINT | BIGINT | Int64 |
UInteger | BIGINT | BIGINT | Int64 |
byte | SMALLINT | SMALLINT UNSIGNED | Int16 |
SByte | SMALLINT | TINYINT | Int16 |
Int16 | SMALLINT | SMALLINT | Int16 |
UInt16 | INT | MEDIUMINT UNSIGNED | Int32 |
Int32 | INT | INT | Int32 |
UInt32 | BIGINT | BIGINT UNSIGNED | Int64 |
Int64 | BIGINT | BIGINT | Int64 |
UInt64 | BIGINT | BIGINT UNSIGNED | Int64 |
Float | REAL | FLOAT | Double |
Double | FLOAT | DOUBLE | Double |
DateTime | DATETIME | DATETIME(3) | DateTime |
String | TEXT | TEXT | String |
NodeId | VARBINARY (max) | BLOB | NodeId |
Provide Feedback