OPC UA and ODBC database data types

Data types map
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

Have questions or feedback about this documentation? Please submit your feedback here.