C语言连接mysql数据库查询中文的数据表乱码问题

来源：互联网发布：英汉翻译软件语音编辑：程序博客网时间：2024/05/31 06:21

用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;}

运行结果为：

0 0