Documentation
- Introduction
-
Concepts
- Architecture
-
Key Features
- Horizontal Scalability
- MySQL Compatible Syntax
- Replicate from and to MySQL
- Distributed Transactions with Strong Consistency
- Cloud Native Architecture
- Minimize ETL with HTAP
- Fault Tolerance & Recovery with Raft
- Automatic Rebalancing
- Deployment and Orchestration with Ansible, Kubernetes, Docker
- JSON Support
- Spark Integration
- Read Historical Data Without Restoring from Backup
- Fast Import and Restore of Data
- Hybrid of Column and Row Storage
- SQL Plan Management
- Open Source
- Online Schema Changes
- How-to
-
Reference
- Tools
- MySQL Compatibility
-
SQL
- SQL Language Structure
- Data Types
-
Functions and Operators
- Function and Operator Reference
- Type Conversion in Expression Evaluation
- Operators
- Control Flow Functions
- String Functions
- Numeric Functions and Operators
- Date and Time Functions
- Bit Functions and Operators
- Cast Functions and Operators
- Encryption and Compression Functions
- Information Functions
- JSON Functions
- Aggregate (GROUP BY) Functions
- Miscellaneous Functions
- Precision Math
-
SQL Statements
- ADD COLUMN
- ADD INDEX
- ADMIN
- ALTER DATABASE
- ALTER TABLE
- ALTER USER
- ANALYZE TABLE
- BEGIN
- COMMIT
- CREATE DATABASE
- CREATE INDEX
- CREATE TABLE LIKE
- CREATE TABLE
- CREATE USER
- DEALLOCATE
- DELETE
- DESC
- DESCRIBE
- DO
- DROP COLUMN
- DROP DATABASE
- DROP INDEX
- DROP TABLE
- DROP USER
- EXECUTE
- EXPLAIN ANALYZE
- EXPLAIN
- FLUSH PRIVILEGES
- FLUSH STATUS
- FLUSH TABLES
- GRANT <privileges>
- INSERT
- KILL [TIDB]
- LOAD DATA
- MODIFY COLUMN
- PREPARE
- RENAME INDEX
- RENAME TABLE
- REPLACE
- REVOKE <privileges>
- ROLLBACK
- SELECT
- SET [NAMES|CHARACTER SET]
- SET PASSWORD
- SET TRANSACTION
- SET [GLOBAL|SESSION] <variable>
- SHOW CHARACTER SET
- SHOW COLLATION
- SHOW [FULL] COLUMNS FROM
- SHOW CREATE TABLE
- SHOW CREATE USER
- SHOW DATABASES
- SHOW ENGINES
- SHOW ERRORS
- SHOW [FULL] FIELDS FROM
- SHOW GRANTS
- SHOW INDEXES [FROM|IN]
- SHOW INDEX [FROM|IN]
- SHOW KEYS [FROM|IN]
- SHOW PRIVILEGES
- SHOW [FULL] PROCESSSLIST
- SHOW SCHEMAS
- SHOW [FULL] TABLES
- SHOW TABLE REGIONS
- SHOW TABLE STATUS
- SHOW [GLOBAL|SESSION] VARIABLES
- SHOW WARNINGS
- SPLIT REGION
- START TRANSACTION
- TRACE
- TRUNCATE
- UPDATE
- USE
- Constraints
- Generated Columns
- Character Set
- Configuration
- Key Monitoring Metrics
- Alert Rules
- Security
- Transactions
- System Databases
- Errors Codes
- Supported Client Drivers
- Garbage Collection (GC)
- Performance
- Best Practices
- TiSpark
- TiDB Binlog Cluster Overview
- Adopters
- FAQs
- Support
- Contribute
- Roadmap
- Releases
ALTER DATABASE
ALTER DATABASE is used to specify or modify the default character set and collation of the current database. ALTER SCHEMA has the same effect as ALTER DATABASE.
Examples
ALTER {DATABASE | SCHEMA} [db_name]
alter_specification ...
alter_specification:
[DEFAULT] CHARACTER SET [=] charset_name
| [DEFAULT] COLLATE [=] collation_nameThe alter_specification option specifies the CHARACTER SET and COLLATE of a specified database. Currently, TiDB only supports some character sets and collations. See Character Set Support for details.