SET @@session.character_set_client=gbk,@@session.collation_connection=28,@@session.collation_server=8/*!*/;

INSERT INTO test_charset SET c=X'2D3E20B8B1B1BE203C2D'

#include "stdafx.h"

#include <assert.h>

#include "mysql.h"

int main(int argc, char* argv[])

{

    int error_code;

    MYSQL*  mysql = mysql_init(NULL);

    assert(mysql != NULL);

    mysql_options(mysql, MYSQL_SET_CHARSET_NAME, "gbk");

    MYSQL*  mysql2 = mysql_real_connect(mysql, "localhost", "root", "", "test", 3307, NULL, 0);

    assert(mysql2 != NULL);

    error_code = mysql_query(mysql, 

        "CREATE TABLE IF NOT EXISTS `test_charset` ("

	    "`c` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',"

	    "`t` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()"

        ")");

    assert(error_code == 0);

    MYSQL_BIND bind;

    MYSQL_STMT *stmt = mysql_stmt_init(mysql);

    assert(stmt != NULL);

    char insert_statement[] = "INSERT INTO test_charset SET c=?";

//    char insert_statement[] = "INSERT INTO test_charset SET c=CONVERT(?, CHAR)";

    error_code = mysql_stmt_prepare(stmt, insert_statement, strlen(insert_statement));

    assert(error_code == 0);

    memset(&bind, 0, sizeof(bind));

    bind.buffer_type   = MYSQL_TYPE_STRING;

    bind.buffer        = "-> \xB8\xB1\xB1\xBE <-";

    bind.buffer_length = strlen((char*)bind.buffer);

    bind.length        = &bind.buffer_length;

    error_code = mysql_stmt_bind_param(stmt, &bind);

    assert(error_code == 0);

    error_code = mysql_stmt_execute(stmt);

    assert(error_code == 0);

    mysql_close(mysql);

	return 0;

}