Why MySQL’s Case‑Insensitive Collation Returns Unexpected Duplicate Brands (and How to Fix It)
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.
