Visual Studio Community 2017 C++与MariaDB/MySQL中文插入乱码决解方法

我的Windows 7 Pro是英文版, 但系统位置是Taiwan, 使用的格式是Chinese (Traditional, Taiwan), 在"Region and Language"中的设定, 在Visual Studio Community 2017写C++与MariaDB/MySQL insert中文出现乱码.

在Visual Studio中的设定为:

在Visual Studio里要设定使用Windows相同语言: Tools->Options->Environment->International Settings->Language: Same as Microsoft Windows. Restart Visual Studio在专案里要设定支援多字元: Project->Properties->General->Character Set: Use Multi-Byte Character Set.在C++里要加入:
if (!mysql_set_character_set(mycon, "big5"))
printf("New client character_set: %s\n", mysql_character_set_name(mycon));

在MariaDB/MySQL的设定为:
MariaDB [file_index]> show variables like "character_set%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+