Release Notes
Product Introduction
- Overview
- Scenarios
- Product Architecture
- Instance Types
- Compatibility Notes
- Usage Recommendations
Kernel Features
- Kernel Overview
- Kernel Version Release Notes
- Functionality Features
- Performance Features
- Security Features
- Columnar Read-Only Analysis Engine Features
Billing
Getting Started
- Creating Instances
- Connect to Instances
User Guide
- Use Limits
- Operation Overview
- Data Migration
- Data Subscription
- Instance Management
- Configuration Change
- Multi-AZ Deployment
- Disaster Recovery Instance
- Monitoring and Alarms
- Parameter Configuration
- Account Management
- Network and Security
- Backup and Restoration
- Log Center
- Database Auditing
- Tag Management
- Serverless Service
- Read-Only Analysis Instance
Use Cases
Developer Guide
- Developer Guide (MySQL Compatibility Mode)
- Developer Guide (HBase Compatibility Mode)
Performance Tuning
- Performance Tuning Overview
- SQL Tuning
- DDL Tuning
Performance White Paper
API Reference
- History
- Introduction
- API Category
- Making API Requests
- Instance APIs
- Security Group APIs
- Task APIs
- Data Security Encryption APIs
- Account APIs
- Backup APIs
- Restore APIs
- Parameter APIs
- Database APIs
- Log APIs
- Other APIs
- Data Types
- Error Codes
General Reference
- System Architecture
- SQL Reference
- Database Parameter Description
- TPC-H benchmark data model reference
- Error Code Information
Security and Compliance
FAQs
Agreements
Contact Us
Glossary

Data Types

Download

Mode fokus

Ukuran font

Terakhir diperbarui: 2026-07-10 11:13:52

This document lists the MySQL data types supported by the read-only analysis instance and their corresponding support details.
Numeric Data Types
Type
System Support
Description
TINYINT
Supported
Supports both signed and unsigned. BOOL and BOOLEAN are also supported as aliases for TINYINT(1).
SMALLINT
Supported
Supports both signed and unsigned.
MEDIUMINT
Supported
Supports both signed and unsigned.
INT,INTEGER
Supported
Supports both signed and unsigned.
BIGINT
Supported
Supports both signed and unsigned. SERIAL is also supported as an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE.
DECIMAL,NUMERIC
Supported
Retains the original precision according to the declared precision and scale (P, S).
FLOAT
Supported
-
DOUBLE
Supported
-
BIT
Supported
The read-only analysis instance uniformly stores the BIT type as a 64-bit unsigned integer, which can fully cover the entire value range of MySQL BIT(M) (where M ranges from 1 to 64). It is only applicable to numerical judgment scenarios.
Date and time data type
Type
System Support
Description
DATE
Supported
-
DATETIME
Supported
Supports fractional seconds.
TIMESTAMP
Supported
Supports fractional seconds.
TIME
Supported
Supports fractional seconds.
YEAR
Supported
-
Character and Binary Data Types
Type
System Support
Description
CHAR
Supported
Stored at the declared fixed length.
VARCHAR
Supported
-
TINYTEXT,TEXT,MEDIUMTEXT,LONGTEXT
Supported
-
BINARY,VARBINARY
Supported
-
TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB
Supported
-
ENUM
Supported
The read-only analysis instance stores and processes ENUM and SET types by converting them to the string type. For SET, multiple members are separated by commas during storage (for example, a,b,c).
Affected by this:
1. Queries based on bitwise operations (for example, operations such as &, |, or ^ applied to SET columns) are not supported.
2. The find_in_set function is supported for searching by member name within a SET column.
SET
﻿
﻿
Spatial data type
Type
System Support
Description
GEOMETRY
Partially supported
Stores raw WKB bytes only as strings, and does not support spatial function operations or spatial indexes.
POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION
Not supported.
-
JSON Data Types
Type
System Support
Description
JSON
Supported
Supports MySQL-compatible JSON functions and path expressions, such as JSON_EXTRACT, ->, ->>, and so on.

Bantuan dan Dukungan

Apakah halaman ini membantu?

Anda juga dapat Menghubungi Penjualan atau Mengirimkan Tiket untuk meminta bantuan.

masukan

tencent cloud

TDSQL Boundless

Data Types

Numeric Data Types

Date and time data type

Character and Binary Data Types

Spatial data type

JSON Data Types

Bantuan dan Dukungan

Type	System Support	Description
TINYINT	Supported	Supports both signed and unsigned. BOOL and BOOLEAN are also supported as aliases for TINYINT(1).
SMALLINT	Supported	Supports both signed and unsigned.
MEDIUMINT	Supported	Supports both signed and unsigned.
INT,INTEGER	Supported	Supports both signed and unsigned.
BIGINT	Supported	Supports both signed and unsigned. SERIAL is also supported as an alias for `BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE`.
DECIMAL,NUMERIC	Supported	Retains the original precision according to the declared precision and scale (P, S).
FLOAT	Supported	-
DOUBLE	Supported	-
BIT	Supported	The read-only analysis instance uniformly stores the BIT type as a 64-bit unsigned integer, which can fully cover the entire value range of MySQL BIT(M) (where M ranges from 1 to 64). It is only applicable to numerical judgment scenarios.