TDSQL-C for MySQL
- Release Notes and Announcements
- Announcements
- Product Introduction
- Suggestions on Usage Specifications
- Kernel Features
- Kernel Version Release Notes
- Optimized Kernel Version
- Functionality Features
- Performance Features
- Security Features
- Stability Feature
- Analysis Engine Features
- Purchase Guide
- Value-Added Services Billing Overview
- Database Audit
- Audit Rule Template
- Serverless Service
- Serverless Introduction
- Serverless Resource Pack
- Configuration Change
- Operation Guide
- Database Connection
- Configuring Network Address
- Instance Management
- Configuration Adjustment
- Instance Mode Management
- Cluster Management
- Scaling Instance
- Database Proxy
- Database Proxy Kernel Features
- Managing Database Proxy
- Automatic Read/Write Separation
- Connection Pool Feature
- Other Features
- Account Management
- Console Account
- Database Account
- Configuring Custom Password Strength
- Database Management
- Database Management Tool
- Columnar Storage Index (CSI)
- Utilization of Columnar Storage Indexes
- Read-Only Analysis Engine
- Feature Limits and Compatibility
- Description of Functions and Operators
- Read-Only Analysis Engine Management
- Data Loading
- Executing Queries
- Exclusive Features
- Performance Optimization
- Performance White Paper
- Parameter Configuration
- Multi-AZ Deployment
- Backup and Restoration
- Performing Backup
- Managing Backup
- Rollback
- Restoring Data from Logical Backups
- Restoring Data Through the Console
- Restoring Data from Snapshot Backup
- Data Migration
- Parallel Query
- Setting Parallel Query
- Database Security and Encryption
- Access and Authorization
- Security Group Management
- TencentDB Security Group Management
- Monitoring and Alarms
- Monitoring
- Alarms
- Monitoring Metric Alarm
- Practical Tutorial
- Data Rollback
- Database/Table-Level Rollback
- Rolling back Entire Cluster
- White Paper
- Security White Paper
- Performance White Paper
- Troubleshooting
- Connection Issues
- API Documentation
- Making API Requests
- Instance APIs
- Account APIs
- Audit APIs
- Database Proxy APIs
- Backup and Restoration APIs
- Parameter Management APIs
- Performance Analysis APIs
- Serverless APIs
- ResourcePackage APIs
- Other APIs
- FAQs
- Service Agreement
- TDSQL-C Policy
- General References
DocumentationTDSQL-C for MySQLOperation GuideRead-Only Analysis EngineFeature Limits and CompatibilityData Types
Data Types
Last updated: 2024-12-13 16:19:31
This document provides a detailed list of data types supported in the read-only analysis engine.
Numeric Data Types
TINYINT
SMALLINT
MEDIUMIN
INT
BIGINT
DECIMAL, NUMERIC
FLOAT
DOUBLE
BIT
Note:
BIT supports data building in the read-only analysis engine, but does not support querying.
Date and Time Data Types
DATE
DATETIMESTAMP
TIMESTAMP
TIME
YEAR
Character Data Types
CHAR
VARCHAR
BINARY
BLOB
TEXT
ENUM
SET
Note:
ENUM and SET support data loading into the read-only analysis engine, but do not support querying.
Spatial Data Types
GEOMETRY
POINT
LINESTRING
POLYGON
Note:
GEOMETRY, POINT, LINESTRING, and POLYGON neither support data loading into the read-only analysis engine nor support querying.
JSON Data Type
Data type mapping and support:
JSON
Note:
JSON supports data loading into the read-only analysis engine, but does not support querying.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No