mysql_set_character_set sets the default character set for a MariaDB Connector/C connection, ensuring mysql_real_escape_string uses the correct encoding.
int mysql_set_character_set(MYSQL * mysql,
const char * csname);mysql - a mysql handle, which was previously allocated by mysql_init() or mysql_real_connect().
csname - character set name
Sets the default character set for the current connection.
Returns zero on success, non-zero on failure.
It is strongly recommended to use mysql_set_character_set() instead of SET NAMES ... since mysql_real_escape_string() might fail or deliver unexpected results.
The client library supports the following character sets:
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
Last updated
Was this helpful?
Was this helpful?