C語言連線mysql資料庫查詢中文的資料表亂碼問題

用C語言呼叫mysql的API函式查詢資料庫中文的表時候顯示亂碼：

例項參考部落格：

http://blog.csdn.net/linux_ever/article/details/50651513

原始碼：

/*************************************************************************
	> File Name:mysql_test.c 
	> Author: 
	> Mail: 
	> Created Time: 2016年02月11日 星期四 10時45分31秒
 ************************************************************************/

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <mysql/mysql.h>

int main()
{
    int ret = 0;

    MYSQL mysql;
    MYSQL * connect = NULL;
    connect = mysql_init(&mysql);
    if(connect == NULL){
        ret = mysql_errno(&mysql);
        printf("mysql_init error, %s\n", mysql_error(&mysql));
        return ret;
    }
    printf("mysql_init ok...\n");


    //connect = mysql_real_connect(connect, NULL, "root", "yxk", "mydb61", 0, NULL, 0);
    connect = mysql_real_connect(connect, "localhost", "root", "yxk", "ch11", 0, NULL, 0);
    if(connect == NULL){
        ret = mysql_errno(&mysql);
        printf("mysql_real_connect error, err is: %s\n", mysql_error(&mysql));
        return ret;
    }
    
    printf("mysql_real_connect ok...\n");
    ret = mysql_query(&mysql, "set names utf8");
    if(ret != 0){
        printf("mysql_query error\n");
        return ret;
    }

    const char * query = "select * from teacher";
    ret = mysql_query(connect, query);
    if(ret != 0){
        printf("mysql_query error\n");
        return ret;
    }

    MYSQL_RES *result = mysql_store_result(&mysql);
    if(result == NULL){
        printf("mysql_store_result error\n");
        return -1;
    }
    
    int field_num = mysql_field_count(&mysql);
    //表頭
    MYSQL_FIELD * fields = mysql_fetch_fields(result);
    int i = 0;

    printf("-------------------------------------------------------------\n");
    for(i= 0; i < field_num; i++){
        printf("%s \t", fields[i].name); 
    }
    printf("\n---------------------------------------------------------------\n");


    //表內容
    MYSQL_ROW row = NULL;
    while(row = mysql_fetch_row(result)){
        for(i= 0; i < field_num; i++){
            printf("%s \t", row[i]); 
        }
        printf("\n");
    }

    mysql_free_result(result);//釋放記憶體

    mysql_close(connect);

    printf("mysql_close...\n");

    return ret;
}

執行結果：

解決辦法：

需要在查詢之前先設定查詢的屬性，設定字符集為utf8；

mysql_query(&mysql, "set names utf8");

解決之後的原始碼：

/*************************************************************************
	> File Name:mysql_test.c 
	> Author: 
	> Mail: 
	> Created Time: 2016年02月11日 星期四 10時45分31秒
 ************************************************************************/

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <mysql/mysql.h>

int main()
{
    int ret = 0;

    MYSQL mysql;
    MYSQL * connect = NULL;
    connect = mysql_init(&mysql);
    if(connect == NULL){
        ret = mysql_errno(&mysql);
        printf("mysql_init error, %s\n", mysql_error(&mysql));
        return ret;
    }
    printf("mysql_init ok...\n");


    //connect = mysql_real_connect(connect, NULL, "root", "yxk", "mydb61", 0, NULL, 0);
    connect = mysql_real_connect(connect, "localhost", "root", "yxk", "ch11", 0, NULL, 0);
    if(connect == NULL){
        ret = mysql_errno(&mysql);
        printf("mysql_real_connect error, err is: %s\n", mysql_error(&mysql));
        return ret;
    }
    
    printf("mysql_real_connect ok...\n");
    ret = mysql_query(&mysql, "set names utf8");
    if(ret != 0){
        printf("mysql_query error\n");
        return ret;
    }

    const char * query = "select * from teacher";
    ret = mysql_query(connect, query);
    if(ret != 0){
        printf("mysql_query error\n");
        return ret;
    }

    MYSQL_RES *result = mysql_store_result(&mysql);
    if(result == NULL){
        printf("mysql_store_result error\n");
        return -1;
    }
    
    int field_num = mysql_field_count(&mysql);
    //表頭
    MYSQL_FIELD * fields = mysql_fetch_fields(result);
    int i = 0;

    printf("-------------------------------------------------------------\n");
    for(i= 0; i < field_num; i++){
        printf("%s \t", fields[i].name); 
    }
    printf("\n---------------------------------------------------------------\n");


    //表內容
    MYSQL_ROW row = NULL;
    while(row = mysql_fetch_row(result)){
        for(i= 0; i < field_num; i++){
            printf("%s \t", row[i]); 
        }
        printf("\n");
    }

    mysql_free_result(result);//釋放記憶體

    mysql_close(connect);

    printf("mysql_close...\n");

    return ret;
}

執行結果為：