Aikesheng Open Source Community
Mar 30, 2022 · Databases
Understanding MySQL HEX/UNHEX Discrepancies and Disabling Binary‑as‑Hex Output
The article explains why MySQL's HEX and UNHEX functions sometimes return hexadecimal representations instead of plain strings, demonstrates the issue with example queries, clarifies the meaning of related functions, and shows how to disable the client’s binary‑as‑hex option to get correct output.
HEXMySQLSQL
0 likes · 7 min read