mysql_set_character_set(3)

💅 mysql_set_character_set — bestie, let's set ur default charset

okay so this one is from the MariaDB Connector/C manual, and it's literally the glow-up your connection needs. it's giving "pick a character set and commit to it" energy. ✨

---

🌸 NAME 🌸

mysql_set_character_set — sets the default character set for the connection, no cap 🎀

---

🦋 SYNOPSIS 🦋

#include <mysql.h>

int mysql_set_character_set(MYSQL * mysql,
                            const char * csname);

---

💖 DESCRIPTION 💖

So basically this sets the default character set for the current connection. that's the whole vibe. ur connection wakes up and chooses its charset like it's picking an outfit.

it returns zero on success, non-zero on failure. periodt.

---

✨ PARAMETERS ✨

• mysql — a mysql handle, which was previously allocated by mysql_init(3) or mysql_real_connect(3). like, it has to already exist bestie, u can't just manifest it 🫶
• csname — character set name. just the name, that's it 💅

---

👑 NOTES 👑

• It's strongly recommended to use mysql_set_character_set() instead of SET NAMES ... since mysql_real_escape_string(3) might fail or deliver unexpected results.

🚨 okay this one matters!! do NOT be out here rawdogging SET NAMES ... and then calling mysql_real_escape_string(3) and acting surprised when it misbehaves. it might fail. it might deliver unexpected results. we do not want that energy. use the function. the function ate. 🔥

---

⭐ RETURN VALUE ⭐

Zero on success, non zero if an error occurred. that's it, that's the whole report card 📝

---

🌈 SUPPORTED CHARACTER SETS 🌈

the client library supports the following character sets, and honestly? the range is iconic:

• armscii8 — 8 bit character set for Armenian
• ascii — US ASCII character set
• big5 — 2 byte character set for traditional Chinese, Hongkong, Macau and Taiwan
• binary — 8 bit binary character set
• cp1250 — Windows code page 1250 character set
• cp1251 — Windows code page 1251 character set
• cp1256 — Windows code page 1256 character set
• cp1257 — Windows code page 1257 character set
• cp850 — MS-DOS Codepage 850 (Western Europe)
• cp852 — MS-DOS Codepage 852 (Middle Europe)
• cp866 — MS-DOS Codepage 866 (Russian)
• cp932 — Microsoft Codepage 932 (Extension to sjis)
• dec8 — DEC West European
• eucjpms — UJIS for Windows Japanese
• euckr — EUC KR-Korean
• gb2312 — GB-2312 simplified Chinese
• gbk — GBK simplified Chinese
• geostd8 — GEOSTD8 Georgian
• greek — ISO 8859-7 Greek
• hebrew — ISO 8859-8 Hebrew
• hp8 — HP West European
• keybcs2 — DOS Kamenicky Czech-Slovak
• koi8r — KOI8-R Relcom Russian
• koi8u — KOI8-U Ukrainian
• latin1 — CP1252 Western European
• latin2 — ISO 8859-2 Central Europe
• latin5 — ISO 8859-9 Turkish
• latin7 — ISO 8859-13 Baltic
• macce — MAC Central European
• macroman — MAC Western European
• sjis — SJIS for Windows Japanese
• swe7 — 7-bit Swedish
• tis620 — TIS620 Thai
• ucs2 — UCS-2 Unicode
• ujis — EUC-JP Japanese
• utf8 — UTF-8 Unicode
• utf16 — UTF-16 Unicode
• utf32 — UTF-32 Unicode
• utf8mb4 — UTF 4-byte Unicode

🙈 if ur wondering: yes, utf8mb4 is right there and yes, it's the main character. but pick whatever ur heart (and ur data) needs. 🧚

---

🎀 SEE ALSO 🎀

• mysql_get_character_set_info(3)
• mysql_real_escape_string(3)

---

Version 3.4 of the manual, bestie — and that's the whole page, mysql_set_character_set(3) out. go set ur charset, slay ur encoding, and remember: escape ur strings properly. mwah 💜🌈