Tag

trailing spaces

0 views collected around this technical thread.

Full-Stack Internet Architecture

Jan 11, 2024 · Databases

MySQL Ignoring Trailing Spaces in VARCHAR Values and How to Enforce Exact Matching

This article demonstrates how MySQL silently discards trailing spaces in VARCHAR columns during queries, shows example tables and queries where spaces are ignored, and explains how to use the BINARY keyword to enforce strict matching of trailing spaces.

MySQLSQLbinary

0 likes · 4 min read

MySQL Ignoring Trailing Spaces in VARCHAR Values and How to Enforce Exact Matching

Zhuanzhuan Tech

Aug 31, 2022 · Databases

MySQL Equality Comparison Ignores Trailing Spaces – Causes and Precise Query Techniques

This article investigates why MySQL treats strings with trailing spaces as equal during "=" comparisons, explains the underlying PAD SPACE collation rule, and demonstrates how to perform exact matches using LIKE and BINARY operators with practical examples and code snippets.

DatabaseLIKEMySQL

0 likes · 7 min read

MySQL Equality Comparison Ignores Trailing Spaces – Causes and Precise Query Techniques