BestHub
Sign in
Tagged articles

Collation

20 articles · Page 1 of 1
Senior Xiao Ying
Senior Xiao Ying
Feb 10, 2026 · Databases

Choosing MySQL Data Types and Constraints for Integrity and Performance

The article explains MySQL’s full range of data types—from integers and floating‑point numbers to strings, binary and temporal types—along with constraint options such as NOT NULL, UNIQUE, CHECK, primary keys and AUTO_INCREMENT, and offers practical guidelines on character sets, collations, and best‑practice selection to ensure data integrity, consistency, and optimal storage and query performance.

Character SetCollationConstraints
0 likes · 11 min read
Choosing MySQL Data Types and Constraints for Integrity and Performance
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
Alibaba Cloud Developer
Alibaba Cloud Developer
Dec 23, 2024 · Databases

Why MySQL Strings Get Garbled: Mastering Charset and Collation

This article dives deep into MySQL's charset and collation system, explaining concepts, configuration levels, system variables, string literals, conversion rules, Unicode sorting algorithms, binary collations, and practical tips to avoid common encoding pitfalls and ensure correct string handling.

CharsetCollationUnicode
0 likes · 57 min read
Why MySQL Strings Get Garbled: Mastering Charset and Collation
IT Services Circle
IT Services Circle
Nov 11, 2024 · Databases

Handling Case Sensitivity in MySQL Brand Table to Prevent Duplicate Entries

This article examines why a MySQL table with a case‑insensitive collation returns uppercase brand names when searching for lowercase input, analyzes the underlying charset and collation settings, and proposes backend pagination with a case‑insensitive fuzzy search and a unique index to reliably prevent duplicate brand records.

Brand ManagementCase InsensitivityCollation
0 likes · 8 min read
Handling Case Sensitivity in MySQL Brand Table to Prevent Duplicate Entries
dbaplus Community
dbaplus Community
Jun 2, 2024 · Databases

Why MySQL Emoji Inserts Fail and How utf8mb4 Fixes Them

This article explains why inserting emoji characters into a MySQL table defined with the default utf8 charset triggers a string‑value error, explores the underlying encoding and charset concepts, compares utf8mb3 and utf8mb4, and shows how to convert tables to avoid such failures.

Character SetCollationEmoji
0 likes · 9 min read
Why MySQL Emoji Inserts Fail and How utf8mb4 Fixes Them
dbaplus Community
dbaplus Community
Mar 12, 2023 · Databases

Why MySQL 8.0 Queries Fail After Upgrading from 5.7: Charset & Collation Pitfalls

When upgrading MySQL 5.7 tables that use utf8 or utf8mb3 to MySQL 8.0, mismatched character sets and collations can cause index loss and inefficient joins, but converting all tables to utf8mb4 and adjusting the driver table can restore optimal query performance, as demonstrated with detailed examples and profiling results.

CharsetCollationQuery Optimization
0 likes · 7 min read
Why MySQL 8.0 Queries Fail After Upgrading from 5.7: Charset & Collation Pitfalls
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 7, 2023 · Databases

Resolving Illegal Mix of Collations Errors in MySQL 8.0 Views

This article analyzes why MySQL 8.0 reports an illegal mix of collations when querying a view that joins tables with different character sets, demonstrates reproducing the issue, explains the role of the CONVERT function and default collation variables, and provides practical recommendations to avoid such errors.

Character SetCollationConvert Function
0 likes · 9 min read
Resolving Illegal Mix of Collations Errors in MySQL 8.0 Views
Su San Talks Tech
Su San Talks Tech
Nov 1, 2020 · Databases

Common MySQL Pitfalls and How to Avoid Them

This article examines common MySQL pitfalls—including signed vs. unsigned integers, auto‑increment key requirements, varchar length versus byte count, case‑insensitive collations, and storing emoji characters—providing concrete SQL examples, error screenshots, and configuration tips to help developers avoid unexpected errors.

CollationDatabase DesignSQL
0 likes · 9 min read
Common MySQL Pitfalls and How to Avoid Them
ITPUB
ITPUB
Jan 11, 2018 · Databases

Master MySQL Character Sets & Collations: When and How to Configure Them

This article explains MySQL character sets and collations, their relationship, how to view supported options, and step‑by‑step methods for configuring them at server, database, table, and column levels, plus guidance on when each setting should be applied.

CollationSQLmysql
0 likes · 14 min read
Master MySQL Character Sets & Collations: When and How to Configure Them
ITPUB
ITPUB
Jun 26, 2017 · Databases

Mastering MySQL Case Sensitivity: Rules, Pitfalls, and 5 Practical Fixes

This article explains how MySQL’s case‑sensitivity depends on the underlying operating system and system variables, outlines the exact rules for databases, tables, columns, and identifiers, discusses the impact on Hibernate/JPA mappings, and provides five concrete solutions—including configuration changes, binary attributes, and collations—to control case handling in MySQL.

Case SensitivityCollationbinary attribute
0 likes · 13 min read
Mastering MySQL Case Sensitivity: Rules, Pitfalls, and 5 Practical Fixes