The "length" property is an integer that specifies the length of a table field. See also: Data types.
It is required to set the length of the following fixed-length data types:
-
"char"(between 1 and 65,500 bytes). -
"binary"(between 1 and 65,500 bytes).
It is required to set the maximum length for the following variable-length data types:
-
"varchar"(between 1 and 65,500 bytes). -
"varbinary"(between 1 and 65,500 bytes).
It is optional to set the maximum length of the "json" data type, which defaults to 2 gigabytes. You may set its maximum length between 1 and 65,500 bytes.
It is optional to set the maximum length of the "number" and "money" data types, which default to 32 numeric digits. You can change the "length" to limit the precision of the number of digits to the left of the decimal point.
-
"number"and"money"are always stored as 32 decimal digits. Using a length less than 32 does not benefit storage. - You may optionally use
"length"to specify fewer than 32 total digits to limit the maximum number of digits in the field. For example, a length of 4 allows numbers such as 12, 123, 1234, 12.34, and 0.1234, but not 12345, 123.45, or 0.12345. - You must always use
"scale"to set the number of decimal places to the right of the decimal point, which must be less than or equal to the length. For example,"money"with a scale of 2, defaults to 30 digits to the left of the decimal point and 2 digits to the right, and"money"with a scale of 4, defaults to 28 digits to the left of the decimal point and 4 digits to the right.
The "length" property is ignored for other data types because they have predefined lengths. For example, "lvarchar" and "lvarbinary" always have a maximum length of 2GB.
Note
"nchar"and"nvarchar"are only supported in FairCom's special UCS-2 server edition. These field types allocate two bytes to each character. Because UCS-2 is inefficient, FairCom recommends its standard database, which supports modern, efficient, variable-length UTF-8 characters.
"nchar"can be between 1 and 65,500 bytes.
"nvarchar"can be between 1 and 65,500 bytes.
Request example
Create a table that contains all field types that use the "length" property.
"fields": [
{
"name": "a",
"type": "char",
"length": 16
},
{
"name": "b",
"type": "varchar",
"length": 65500
}
],