Firebird
This section contains information on the configuration and the data type mapping of Firebird databases with ODBC.
Declaration in the TwinCAT Database Server Configurator
ODBC Firebird database | |
---|---|
Database Type | "Odbc_Database" |
ODBC Type | Select "Firebird" from the drop-down menu. |
Driver | Select here the actually installed driver. |
Database | Enter the name of the database. |
Client |
|
Uid | Enter the user name here. |
Pwd | Enter the corresponding password. |
Data type mapping between DB and PLC
E_ColumnTypes | Firebird | TwinCAT PLC |
---|---|---|
BigInt | BIGINT | T_ULARGE_INTEGER (TcUtilities.lib) |
Integer | INTEGER | DINT |
SmallInt | SMALLINT | INT |
TinyInt | TINYINT | INT |
Bit_ | CHAR(1) | STRING |
Money | DECIMAL(18,4) | LREAL |
Float | FLOAT | REAL |
Real_ | DOUBLE PRECISION | LREAL |
DateTime | TIMESTAMP | DT |
NText | VARCHAR(254) | STRING |
NChar | CHAR(254) | STRING |
Image | BLOB | ARRAY OF BYTE |
NVarChar | VARCHAR(254) | STRING |
Binary | BLOB | ARRAY OF BYTE |
VarBinary | BLOB | ARRAY OF BYTE |
Data type support WSTRING is not supported by this database. (See WString support) |
Functioning All functions of the TwinCAT Database Server can be applied to the ODBC templates. This does not apply to the "Free Connection String". |
Notice | |
Data security In flash memory devices the number of write access operations is limited. The flash memory devices can fail, with a risk of data loss.
|