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 #58 background imageLoading...
Page #58 background image
3 Programming the DB Connection Function
3-6
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Data type category
Data type in DB
Data type in NJ/NX-series Controllers
numeric(20)
numeric(3)
numeric(5)
numeric(10)
ULINT
USINT
UINT
UDINT
numeric(19)
TIME
smallint INT
USINT
smallmoney
REAL
*5
tinyint
USINT
float
LREAL
real
REAL
Date and time
date
DATE
datetime2
DATE_AND_TIME
*6
datetime
DATE_AND_TIME
datetimeoffset
DATE_AND_TIME
*6
smalldatetime
DATE_AND_TIME
time
TIME_OF_DAY
*6
String
char
STRING
*7
text
STRING
*7
varchar
STRING
*7
nchar
STRING
*7
ntext
STRING
*7
nvarchar
STRING
*7
Binary
binary
None
image
None
varbinary
None
Others
cursor
None
hierarchyid
None
sql_variant
None
table
None
uniqueidentifier
None
xml
None
*1 The decimal (p[ ,s]) and numeric (p[ ,s]) are expressed in the short form where the number of digits
after the decimal point (s) is omitted. When the short form is used, the number of digits after the
decimal point (s) is 0. If the number of digits after the decimal point (s) is not omitted and 1 or
greater numerical value is set, only the integer portion of the value is applicable.
*2 Integer in units of nanoseconds
*3 Digit overflow may occur even in the above data types due to the difference in the valid range.
Example: When the data type in DB is decimal(3) and the data type in NJ/NX-series Controllers is
USINT:
decimal(3)’s range: 0 to 999
USINT’s range: 0 to 255
*4 The significant figures are 15 digits. When the data is written to the DB by a DB Connection
Instruction, a value rounded to four decimal places is written.
Example: When 1.79769 is written to the DB, 1.7977 is written.
*5 The significant figures are 7 digits. When the data is written to the DB by a DB Connection
Instruction, a value rounded to four decimal places is written.
Example: When 1.79769 is written to the DB, 1.7977 is written.
*6 The accuracy is milliseconds.
*7 A NULL character is attached to the end of each text string. Therefore, you need to set the value
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.

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