mysql_hex_string(3)

✨ NAME ✨

mysql_hex_string — bestie, it makes you a hexadecimal string 💅

So like, this page is mysql_hex_string(3) from the MariaDB Connector/C manual, and we're gonna get you fluent in it, no cap.

🌸 SYNOPSIS 🌸

#include <mysql.h>
unsigned long mysql_hex_string(char * to,
                               const char * from,
                               unsigned long len);

🦋 DESCRIPTION 🦋

Okay so picture this: you need a hex string you can literally drop straight into a SQL statement. That's the whole gig. It's giving "encode my bytes so the database doesn't get confused."

Like, for example:

INSERT INTO my_blob VALUES(X'A0E1CD')

That's the vibe. mysql_hex_string is the girl who hands you the A0E1CD part. 🎀

💖 PARAMETER 💖

• to — your result buffer, aka where the glow-up gets written ✨
• from — the string that's getting encoded, the raw material, the before pic 📸
• len — the length of that from string, gotta know how much we're working with

👑 NOTES 👑

• The buffer you make for the encoded string must be 2 * length + 1 in size. Not negotiable, bestie, do the math and give it room to breathe 🫶
• The encoded string does not contain a leading X'. You get the bare hex, you add the dressing yourself 💅

⭐ RETURN VALUE ⭐

It returns the length of the encoded string, and that's without the trailing null character. So don't come for the null, she's not in the count 🙈

🌈 SEE ALSO 🌈

• mysql_real_escape_string(3) — her sister, also iconic, also does escaping

Okay that's the whole page, mwah 💜 Sending you off with the official receipts: this was Version 3.4, and yes, she's mysql_hex_string(3), still the moment, still serving. Go hex something, you absolute legend 👑✨