mysql_set_character_set

Syntax

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

Description

Sets the default character set for the current connection. Returns zero on success, non-zero on failure.

It's 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:

Character set	Description
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

See also

• mysql_real_escape_string()