MQTT V3 Plug-in Reference

"fieldWidth"

• Integer
• Specifies the width of a table field

Required to set fixed lengths for the following data types:

• "CHAR" (between 1 and 8,192)
• "NCHAR" (between 1 and 65,535)
• "BINARY" (between 1 and 8,192)

Optional to set maximum lengths for the following data types:

• "VARCHAR" (between 1 and 8,192)
• "NVARCHAR" (between 1 and 65,535)
• "VARBINARY" (between 1 and 65,535)

Ignored for other data types because they have predefined widths.

Examples

"MONEY" has 10 digits with 2 decimal places.

"NUMBER" has a fixed width of 32 decimal digits.

"LVARCHAR", "LVARBINARY", and "JSON" are variable-length up to 2GB in size.

"fieldScale"

• Integer
• Defaults to 0
• Required only for "NUMBER"

It is the number of digits to the right of the decimal point.