Types

The standard platform collection can handle the following data types:

Type Name Representation
String A standard string of characters, UTF8 encoded
Int A 32 bit signed integer
Bigint A 64 bit signed integer
Float A 32 bit floating point number
Double A 64 bit floating point number
Blob A binary blob of arbitrary size
Uuid A standard Uuid (sometimes called a GUID)
Timestamp An RFC 3339 timestamp
Boolean A boolean value; true or false

In addition, null values are allowed in all collection columns except the “item_id” column, which is supplied by the platform.

When accessing data from a collection, the platform returns values in JSON format. Therefore, numeric values will be returned with a data type of Double. The platform returns Blobs as base64 encoded strings.