ODBC - MySQL Database
The values of the variables are saved in a MySQL database.
The variable values are saved in the following table structure.
Column name | Data type | Null permitted | Characteristic |
|---|---|---|---|
ID | INTEGER | no | IDENTITY(1,1) |
Timestamp | DATETIME | no |
|
Name | VARCHAR(50) | no |
|
ValueType="Double" | |||
Value | DOUBLE | no |
|
ValueType="Bytes" | |||
Value | BLOB | no |
|
An AutoID is generated in the "ID" column. The value in this column is, in other words, always increased by 1. This functionality makes the IDENTITY property possible.
The "Timestamp" column stores the time at which the data record was saved.
The name of the variable is stored in the "Name" column.
The "Value" column stores the value of the variable.
E_DBColumnTypes | MySQL | PLC Control |
|---|---|---|
eDBColumn_BigInt | BIGINT | T_ULARGE_INTEGER (TcUtilities.lib) |
eDBColumn_Integer | INT | DINT |
eDBColumn_SmallInt | SMALLINT | INT |
eDBColumn_TinyInt | TINYINT | SINT |
eDBColumn_Bit | CHAR(1) | BYTE |
eDBColumn_Money | DEZIMAL(18,4) | LREAL |
eDBColumn_Float | DOUBLE | LREAL |
eDBColumn_Real | FLOAT | REAL |
eDBColumn_DateTime | DATETIME | DT |
eDBColumn_NText | TEXT | STRING |
eDBColumn_NChar | CHAR | STRING |
eDBColumn_Image | BLOB | ARRAY OF BYTE |
eDBColumn_NVarChar | VARCHAR(254) | STRING |
eDBColumn_Binary | BLOB | ARRAY OF BYTE |
eDBColumn_VarBinary | BLOB | ARRAY OF BYTE |