edit-icon download-icon

Data types supported by Table Store

Last Updated: Apr 11, 2018

Table Store supports the following data types: Integer, String, Boolean, and Double.

  • Integer indicates a 64-bit signed integer, such as 23, -908, and +87. The values of the Integer type range from -9,223,372,036,854,775,808 to +9,223,372,036,854,775,807.

  • String indicates a UTF-8 string, which is enclosed by a pair of single quotation marks (‘) at input, for example, ‘Test’, ‘Open Table Service’, and ‘Table Store User Guide’. The length of a string ranges from 0 KB to 512 KB. We recommend that the length not exceed 1,024 bytes.

  • Boolean indicates data of the Boolean type, which can be set to either TRUE or FALSE.

  • Double indicates a floating-point number in the 64-bit format of the IEEE 754 standard, for example, 1.23, -34.0. +102.23, 1.0e-10, and 2.006E+3.

Note:

  • The Double type is not applicable to the primary key columns of a table or view.
  • The Double and Boolean types are not applicable to the data partition key, that is, the first column of the primary key.
Thank you! We've received your feedback.