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
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
