BestHub
Sign in
Tag

Charset

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 1, 2025 · Databases

Resolving Column Length Expansion Errors in OceanBase: Charset and Collation Considerations

This article explains why altering a column length in OceanBase may trigger an "Alter charset or collation type not supported" error, analyzes the underlying charset and collation settings, and provides a solution that explicitly specifies charset and collation to ensure successful column expansion across versions.

CharsetCollationColumn Expansion
0 likes · 6 min read
Resolving Column Length Expansion Errors in OceanBase: Charset and Collation Considerations
Aikesheng Open Source Community
Aikesheng Open Source Community
May 21, 2024 · Databases

Avoiding Implicit Type Conversions in MySQL to Preserve Index Usage

This article explains common scenarios of implicit type and charset conversions in MySQL, demonstrates how they cause index loss and performance degradation through detailed examples and EXPLAIN output, and provides practical guidelines to prevent such conversions in production environments.

CharsetImplicitConversionIndexOptimization
0 likes · 15 min read
Avoiding Implicit Type Conversions in MySQL to Preserve Index Usage
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 7, 2019 · Databases

Performance Impact of Charset and Collation Settings on MySQL 5.7 vs 8.0

A sysbench benchmark comparing MySQL 5.7.25 and MySQL 8.0.15 shows that latin1 charset favors 5.7, while utf8mb4 dramatically improves 8.0 performance, and that collations such as utf8mb4_unicode_ci can further affect query speed.

CharsetCollationDatabase Benchmark
0 likes · 4 min read
Performance Impact of Charset and Collation Settings on MySQL 5.7 vs 8.0
360 Quality & Efficiency
360 Quality & Efficiency
Jun 11, 2018 · Databases

Recovering a Crashed MySQL Server Using innodb_force_recovery and Data Export/Import

This article walks through diagnosing a MySQL crash, using innodb_force_recovery to start the server, exporting the data with mysqldump, handling charset mismatches, importing into a new instance, and restoring normal operation while offering best‑practice backup recommendations.

BackupCharsetDatabase Recovery
0 likes · 5 min read
Recovering a Crashed MySQL Server Using innodb_force_recovery and Data Export/Import
360 Quality & Efficiency
360 Quality & Efficiency
Mar 26, 2018 · Databases

Handling Case Sensitivity in MySQL: Collation, Data Types, and Query Solutions

This article explains why MySQL queries can become case‑insensitive, describes how collations and character sets control case sensitivity, and presents three practical solutions—changing the collation, converting column types, and using binary or collate clauses in queries—to achieve case‑sensitive behavior.

CharsetCollationDatabase
0 likes · 5 min read
Handling Case Sensitivity in MySQL: Collation, Data Types, and Query Solutions