EasyManuals Logo

Omron NX701-1620 User Manual

Omron NX701-1620
306 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #60 background imageLoading...
Page #60 background image
3 Programming the DB Connection Function
3-8
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
that is one byte bigger than the number of bytes of the DB’s data type for the number of bytes to be
used in STRING data.
You need to set an appropriate value for the number of bytes used in the STRING data according
to the data type and character code in the DB. In NJ/NX Series, text strings are handled as UTF-8.
One byte is used for each single-byte alphanumeric character and multiple bytes are used for each
multi-byte character. Three bytes are used for each Japanese character as a guide.
ï‚– MySQL
Data type category
Data type in DB
Data type in NJ/NX-series Controllers
Numbers
*1
BIT BOOL
BOOL
BOOLEAN
BOOL
TINYINT SINT
USINT
SMALLINT INT
UINT
MEDIUMINT DINT
UDINT
INT DINT
UDINT
BIGINT LINT
ULINT
TIME
DECIMAL(1)
DECIMAL(3)
DECIMAL(5)
DECIMAL(10)
DECIMAL(20)
DECIMAL(3)
DECIMAL(5)
DECIMAL(10)
DECIMAL(20)
*2
BOOL
SINT
INT
DINT
LINT
USINT
UINT
UDINT
ULINT
DECIMAL(20)
TIME
FLOAT
REAL
DOUBLE
LREAL
Date and time
DATE
DATE
DATETIME
DATE_AND_TIME
TIMESTAMP
DATE_AND_TIME
TIME
TIME_OF_DAY
String
CHAR
STRING
*3
VARCHAR
STRING
*3
TINYTEXT
STRING
*3
TEXT
STRING
*3
MEDIUMTEXT
STRING
*3
LONGTEXT
STRING
*3
Binary
BINARY
None
VARBINARY
None
TINYBLOB
None
BLOB
None
MEDIUMBLOB
None
LONGBLOB
None
Others
ENUM
None
YEAR
None
SET
None

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the Omron NX701-1620 and is the answer not in the manual?

Omron NX701-1620 Specifications

General IconGeneral
BrandOmron
ModelNX701-1620
CategoryController
LanguageEnglish

Related product manuals