Data Type

Last updated: 2025-04-29 23:09:06

Data Type

Last updated: 2025-04-29 23:09:06

The data types supported by default in TencentDB for CTSDB 3.0 are shown in the following table‌. For more usage examples, see Data types.
Datatype
Field
Value
Description
 Float
(Floating-Point Type)
Field values
64-bit
Describes numeric data in time series data, which can be used to store measurement values, sensor data, network traffic, CPU utilization, and more.
Integer
(Integer Type)
Field values
Signed 64-bit integer (-9223372036854775808 to 9223372036854775807)
Describes count data in time series data, which can store counters, event occurrences, number of user visits, and more. These data are usually non-negative integers.
String
(Character Type)
Measurements, tag
keys, tag values, field keys, field values
﻿
Length limit 64 KB
Describes text data in time series data, which can be used for measurements, tag keys, tag values, field keys, and field values and store device names, log messages, status information, and more.
Boolean
(Boolean Type)
Field values
TRUE or FALSE
Describes data with only two possible values, namely "True" and "False". In data analysis and programming, the Boolean type is commonly used to represent logical conditions, enabling status, and whether a certain condition is met.
Timestamp (Time Type)
Timestamps
Unix nanosecond timestamp
The minimum valid timestamp is: 9223372036854775806 or 1677-09-21T00:12:43.145224194Z.
The maximum valid timestamp is: 9223372036854775806 or 2262-04-11T23:47:16.854775806Z.
Indicates a time interval starting from a specific time point. In InfluxDB, timestamps are stored in UTC format and can be precise to the nanosecond level.
Note:
Field values can be floating-point numbers, integers, strings, or Boolean values. Field value types within the same shard should be identical. Using different data types between different shards may result in data inconsistency or errors. Therefore, avoid doing so whenever possible.

Was this page helpful?

You can also Contact Sales or Submit a Ticket for help.

Yes

Feedback

Datatype	Field	Value	Description
Float (Floating-Point Type)	Field values	64-bit	Describes numeric data in time series data, which can be used to store measurement values, sensor data, network traffic, CPU utilization, and more.
Integer (Integer Type)	Field values	Signed 64-bit integer (-9223372036854775808 to 9223372036854775807)	Describes count data in time series data, which can store counters, event occurrences, number of user visits, and more. These data are usually non-negative integers.
String (Character Type)	Measurements, tag keys, tag values, field keys, field values	Length limit 64 KB	Describes text data in time series data, which can be used for measurements, tag keys, tag values, field keys, and field values and store device names, log messages, status information, and more.
Boolean (Boolean Type)	Field values	TRUE or FALSE	Describes data with only two possible values, namely "True" and "False". In data analysis and programming, the Boolean type is commonly used to represent logical conditions, enabling status, and whether a certain condition is met.
Timestamp (Time Type)	Timestamps	Unix nanosecond timestamp The minimum valid timestamp is: 9223372036854775806 or 1677-09-21T00:12:43.145224194Z. The maximum valid timestamp is: 9223372036854775806 or 2262-04-11T23:47:16.854775806Z.	Indicates a time interval starting from a specific time point. In InfluxDB, timestamps are stored in UTC format and can be precise to the nanosecond level.

tencent cloud