Mitsubishi Electric MELSEC iQ-R Series User Manual page 49

*1 The data types of PostgreSQL are as follows:
Data type classification
Integer
Real number
*2 The data type of an access field 'real number [floating point]' is also supported.
*3 Cannot be used for a DB procedure argument.
RD81MES96
Data category
Device tag component
Variable
Constant
Macro
Access field
Access procedure argument
DB field Oracle
DB procedure argument
Microsoft SQL
Server
Microsoft Access
MySQL
PostgreSQL
*1 Cannot be used for a DB procedure argument.
Access procedure argument data type
Integer [smallint]
Integer [integer]
Integer [bigint]
Real number [numeric]
Real number [real]
Real number [double precision]
Numerical value
Integer
• Bit
• Word [unsigned]/Bit string [16-bit]
• Double word [unsigned]/Bit string [32-bit]
• Word [signed]
• Double word [signed]
• 16bit BCD
• 32bit BCD
• Bit
• Word [unsigned]/Bit string [16-bit]
• Double word [unsigned]/Bit string [32-bit]
• Word [signed]
• Double word [signed]
Integer
Any of the data types of the device tag component or variable is determined for each macro.
Integer
Integer

• bit
• tinyint
• smallint
• int
• bigint
*1
• Yes/No type
• Number: Byte
• Number: Integer
• Number: Long Integer
• TINYINT [UNSIGNED]
• SMALLINT [UNSIGNED]
• MEDIUMINT [UNSIGNED]
• INT [UNSIGNED]
• BIGINT [UNSIGNED]
• smallint
• integer
• bigint
Database data type
smallint
integer
bigint
numeric
real
double precision
Real number
• Single-precision real number
• Double-precision real number
• Single-precision real number
• Double-precision real number
Real number
Real number [floating point]
Real number
• NUMBER(p) • NUMBER(p, s)
• NUMBER(p, 0) • NUMBER
• BINARY_FLOAT
• BINARY_DOUBLE
• decimal • real
• numeric • float
• decimal(p)
• numeric(p)
• decimal(p, 0)
• numeric(p, 0)
• Number: Decimal • Number: Decimal
• Number: Single
• Number: Double
• DECIMAL[(M[,0])] • DECIMAL(M,D) [UNSIGNED]
[UNSIGNED] • FLOAT [UNSIGNED]
• DOUBLE [UNSIGNED]
• numeric(p[,0]) • numeric[(p,s)]
• real
• double precision
2.4 Data Specifications
2 SPECIFICATIONS
47
2