OPC UA 和 ODBC 数据库数据类型
FactoryTalk Optix 数据类型 | Microsoft® SQL Server 数据类型 | MySQL 数据类型 | 由查询的 SQL 数据库返回的数据类型 |
---|---|---|---|
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 |
提供反馈