#include <stdio.h>

#include <mysql.h>

#include <windows.h>

void

checkClientCharacterSet(MYSQL* mysql) {

    mysql_query(mysql, "SHOW SESSION VARIABLES LIKE 'character_set_client'");

    MYSQL_RES* result = mysql_store_result(mysql);

    int totalrows = mysql_num_rows(result);

    int numfields = mysql_num_fields(result);

    MYSQL_ROW row = mysql_fetch_row(result);

    fprintf(stdout, "%s \t %s\n", row[0], row[1]);

}

int

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

    if (argc <2) {

        fprintf(stderr, "Please enter server host name\n");

        return 1;

    }

    // Set to Windows UTF-8 code page

    // Note without this using the default code page of 437 the character_set_client will return 'latin1'

    SetConsoleCP(65001);

    mysql_library_init(0, NULL, NULL);

    MYSQL* mysql_ = mysql_init(NULL);

    //mysql_optionsv(mysql_, MYSQL_SET_CHARSET_NAME, "utf8"); // This works

    mysql_optionsv(mysql_, MYSQL_SET_CHARSET_NAME, MYSQL_AUTODETECT_CHARSET_NAME);

    if(!mysql_real_connect(mysql_, argv[1], "user", "pass", "db", 3306, NULL, 0)) {

        fprintf(stderr, "Connection to %s failed\n", argv[1]);

        mysql_close(mysql_);

        return 1;

    }

    checkClientCharacterSet(mysql_);

    mysql_close(mysql_);

    mysql_library_end();

    return 0;

}