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.