Mitsubishi Electric MELSEC iQ-R Series User Manual page 50

Character string, date and time
Data category
Device tag component
Variable
Constant
Macro
Access field
Access procedure argument
DB field
DB procedure argument
*1 The data types of PostgreSQL are as follows:
Data type classification
Character string [Unicode]
Date and time [without time zone]
*2 The date from January 1st in 4712 B.C. to December 31st in 9999 A.D. in Julian calendar can be stored. However, the date in B.C.
cannot be handled in an MES interface module.
*3 Cannot be specified for a DB procedure argument.
*4 Cannot be used for a DB procedure argument.
*5 Notation in Access 2013 or later
*6 When using it for a DB procedure argument, use the character code utf8, utf8mb3, or utf8mb4.
*7 Can be specified when the character set setting in a field of a database is utf8.
*8 Can be specified when the character set setting in a field of a database is not utf8.
*9 The date from January 1st in 4713 B.C. to December 31st in 294276 A.D. in Gregorian calendar can be stored. However, the date in
B.C. cannot be handled in an MES interface module.
*10 Can be specified when the character set setting in a field of a database is utf8mb3.
*11 Can be specified when the character set setting in a field of a database is not utf8mb3.
2 SPECIFICATIONS
48
2.4 Data Specifications
Character string
• Character string [Unicode]
• Character string [ASCII/SJIS]
• Character string [Unicode]
• Character string [Unicode]
Any of the data types of the device tag component or variable is determined for each macro.
• Character string
[Unicode(NCHAR)]
• Character string [Unicode]
Oracle • NCHAR
• NVARCHAR2
Microsoft SQL • nchar
Server • nvarchar
*4

Microsoft Access
MySQL • [NATIONAL]
CHAR[(M)]
• [NATIONAL]
VARCHAR(M)
• CHAR[(M)]
• VARCHAR(M)

PostgreSQL
MariaDB • [NATIONAL]
CHAR[(M)]
• [NATIONAL]
VARCHAR(M)
• CHAR[(M)]
• VARCHAR(M)
Access procedure argument data type
Character string [character]
Character string [character varying]
Date and time [timestamp]
• Character string
[Unicode(CHAR)]
*1
• CHAR
• VARCHAR2
• char
• varchar
• Text type (short
*5
text )
*6*8
• CHAR[(M)]
*6 *6*8
• VARCHAR(M)
*6
*6*7
*6*7
• character[(n)]
• character
varying[(n)]
*11
• CHAR[(M)]
*11
• VARCHAR(M)
*10
*10
Date and time

Date and time [without
time zone]
Date and time [without
*1
time zone]
*2
• DATE
*2
• TIMESTAMP[(p)]
• smalldatetime
• datetime
• datetime2[(p)]
• Date/Time
• DATETIME[(fsp)]
• TIMESTAMP[(fsp)]
• timestamp[(p)] [without
*9
time zone]
• DATETIME[(fsp)]
• TIMESTAMP[(fsp)]
Database data type
character[(n)]
character varying[(n)]
timestamp[(p)] [without time zone]
Date and time [with time
zone]

• TIMESTAMP[(p)] WITH
*2*3
TIME ZONE
*3
• datetimeoffset[(p)]



