Data Types

A data type provides a set of values from which an expression (i.e. variable, function, etc.) may take its values.

Xano supports a number of different data types to be used in the building of your database.

Text: variable-length character string.

Text field type
Customize with

Integer: signed four-byte integer with a range between -2147483648 to +2147483647.

Integer field type

Object: can point to data of any data type. You can assign a variable, constant, or expression of any data type to an object.

Table Reference: this is an integer that references another table using the id #.

Table reference

File: upload a file.

Image Metadata: this allows you to upload any image files. For example: .jpg.

Video Metadata: this allows you to upload any video files. For example: .mp4.

Attachment Metadata: this allows you to upload any files with the exception of .exe.

Bool: logical Boolean (true/false).

Decimal: data type ranges from 131072 digits before the decimal point to 16383 digits after the decimal point.

Email: email address format: [email protected]

JSON: JavaScript Object Notation, the basic data types are: Number, String, Boolean, Array, Object, and null.

Password: this is a special case where the data is automatically encrypted using salt encryption.

Salt in cryptography, is random data that is used as an additional input to a one-way function that hashes data, a password or passphrase. Salts are used to safeguard passwords in storage.

Timestamp: this is the number of milliseconds that have elapsed since the Unix epoch.

Enum: a special data type that enables for a variable to be a set of predefined constants. The variable must be equal to one of the values that have been predefined for it.

Point (geo_point): a special type that represents a point on the map using latitude and longitude.

Point Collection (geo_multipoint): a special type that represents a collection of points on one map using latitude and longitude.

Path (geo_linestring): a collection of points that represent a line on a map using latitude and longitude of each point.

Path Collection (geo_multilinestring): a collection of lines on one map.

Polygon (geo_polygon): a collection of lines that form a multi-sided shape on a map.

Polygon Collection (geo_multipolygon): a collection of polygons on one map.