Tagged articles
collation
22 articles · Page 1 of 1
This tutorial demonstrates MySQL 8.0 configuration of character sets, collations, time zones, and SQL modes through reproducible experiments, showing how connection settings differ from server defaults, how utf8mb4 handles emojis, why TIMESTAMP converts across time zones while DATETIME does not, and how strict SQL mode rejects out-of-range values.
MySQLcharacter-setcollation
0 likes · 20 min read

The article explains the difference between character sets and encodings, shows that MySQL’s utf8 is actually an alias for utf8mb3, demonstrates how using the wrong charset or collation causes garbled data, and provides practical steps to consistently use utf8mb4 across versions and connections.
MySQLcharacter-setcollation
0 likes · 13 min read

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.
Database DesignMySQLcharacter-set
0 likes · 11 min read

This article explains MySQL's supported character sets and collations, shows how to list them, demonstrates table‑level and column‑level definitions, clarifies naming conventions, and provides practical examples for verifying and altering collations to ensure correct string comparison and storage.
MySQLSQLcharacter-set
0 likes · 10 min read

This article explains why MySQL 8.0 replication to a 5.7 slave fails because of the new utf8mb4_0900_ai_ci collation, analyzes the root causes, and provides step‑by‑step configuration and SQL‑based solutions to ensure a smooth upgrade without data loss.
Binary LogDatabase MigrationMySQL
0 likes · 9 min read

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.
CharsetColumn ExpansionOceanBase
0 likes · 6 min read

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.
CharsetMySQLUnicode
0 likes · 57 min read

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 InsensitivityDatabase Design
0 likes · 8 min read

This article examines a puzzling MySQL case‑insensitive collation issue where a user‑defined brand "yoyo" cannot be saved because the database returns an existing uppercase "YOYO" entry, explains the underlying COLLATE settings, and proposes practical solutions to prevent duplicate brand data.
Brand ManagementMySQLSQL
0 likes · 8 min read

This article explains why upgrading MySQL from 5.7 to 8.0 can cause an "Illegal mix of collations" error in FIND_IN_SET queries, analyzes the root cause, and presents three practical solutions—adjusting server parameters, altering table collations, or rewriting the SQL—to restore correct operation.
MySQLSQLUpgrade
0 likes · 10 min read

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.
MySQLcharacter-setcollation
0 likes · 9 min read

This article explores MySQL character set implementation by analyzing system tables (CHARACTER_SETS and COLLATIONS) in information_schema and tracing internal source code structures like CHARSET_INFO, initialization logic, and client connection handling.
Client-Server ProtocolDatabase InternalsMySQL
0 likes · 6 min read

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.
CharsetMySQLcollation
0 likes · 7 min read

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.
Convert FunctionMySQLcharacter-set
0 likes · 9 min read

This article explains MySQL collations and character sets, shows how to view and set them, and demonstrates through test cases that while data insertion is unaffected by collation, query results are influenced by the collation defined on columns or the connection.
MySQLcharacter-setcollation
0 likes · 6 min read

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.
Database DesignMySQLSQL
0 likes · 9 min read

This article explains how to specify and manage character sets and collations when creating or altering MySQL databases, tables, views, triggers, and columns, illustrating the impact on stored procedures and data retrieval with practical SQL examples.
MySQLSQLTable
0 likes · 11 min read

This article explains MySQL character sets and collations, describes common character sets such as latin1, utf8mb3, utf8mb4 and gb18030, shows how to query available sets and collations, compares PAD SPACE and NO PAD behavior, and provides step‑by‑step migration examples between utf8, utf8mb3 and utf8mb4.
MySQLcharacter-setcollation
0 likes · 12 min read

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.
CharsetDatabase BenchmarkMySQL
0 likes · 4 min read

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.
Case SensitivityCharsetMySQL
0 likes · 5 min read


ITPUBJan 11, 2018 · Databases
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.
MySQLSQLcollation
0 likes · 14 min read


ITPUBJun 26, 2017 · Databases
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 SensitivityMySQLbinary attribute
0 likes · 13 min read
