Mitsubishi Electric MELSEC iQ-R-R6SFM - Specifications

13 DATABASE FUNCTION
13.1 Specifications
233
13
13.1 Specifications
Database specifications
The following table lists specifications of databases which the user can create.
*1 For the programmable controller CPU with firmware version earlier than "28", up to 16 fields can be created per table.
*2 For the programmable controller CPU with firmware version earlier than "28", up to 100000 records can be created per table.
*3 For the programmable controller CPU with firmware version earlier than "28", up to 16 tables can be created per database.
*4 For rough standards of the access time depending on the database size, refer to the following.
Page 922 Database function processing time
■Data type
The following table lists the data types that can be used in the table created by using the database access instructions and the
corresponding data types for the CPU module database access function.
The following table lists the data types that can be used in the table created by the CPU module database access function and
the corresponding data types for the database access instructions.
Item Description
The maximum number of fields 128 fields per table
*1
The maximum number of records No limitation (they can be created up to the capacity of the SD memory card)
*2*4
The maximum number of tables 32 tables per database
*3
The maximum number of databases No limitation (they can be created up to the capacity of the SD memory card)
The maximum number of concurrently connectable
databases (number of connections)
4
The maximum number of characters of a field name 32 single-byte alphabetical characters
The maximum number of characters of a table name 32 single-byte alphabetical characters
Corresponding data type Page 233 Data type
Data type that can be used in the table
created by using the database access
instruction
Range Corresponding data type for the CPU
module database access function
BOOL: Bit 0, 1 BOOLEAN: Bit
WORD: Unsigned 16-bit numerical value 0 to 65535 INT: Unsigned 16-bit numerical value
DWORD: Unsigned 32-bit numerical value 0 to 4294967295 BIGINT: Unsigned 32-bit numerical value
INT: Signed 16-bit numerical value -32768 to 32767 INT: Signed 16-bit numerical value
DINT: Signed 32-bit numerical value -2147483648 to 2147483647 BIGINT: Signed 32-bit numerical value
REAL: Single-precision real number E1.175495-38 to E3.402823+38 REAL: Single-precision real number
LREAL: Double-precision real number E2.22507385850721-308 to
E1.79769313486231+308
DOUBLE PRECISION: Double-precision real
number
STRING: String (Shift-JIS code) Number of supported characters: 1 to 124 NLSCHAR: String (Unicode)
WSTRING: String (Unicode) Number of supported characters: 1 to 124 NLSCHAR: String (Unicode)
Data type that can be used in the table
created by the CPU module database
access function
Range Corresponding data type for the
database access instruction
BOOLEAN: Bit 0, 1 BOOL: Bit
INT: Signed 16-bit numerical value -32768 to 32767 INT: Signed 16-bit numerical value
BIGINT: Signed 32-bit numerical value -2147483648 to 2147483647 DINT: Signed 32-bit numerical value
REAL: Single-precision real number E1.175495-38 to E3.402823+38 REAL: Single-precision real number
DOUBLE PRECISION: Double-precision real
number
E2.22507385850721-308 to
E1.79769313486231+308
LREAL: Double-precision real number
NLSCHAR: String (Unicode) Number of supported characters: 1 to 124 WSTRING: String (Unicode)