- 论坛徽章:
- 0
|
数据库的表名为offlinemsg
结构为:
uid int not null,
msg varchar(1024) not null
写了一段查询数据的C代码:- MYSQL mysql;
- MYSQL_RES *res;
- MYSQL_ROW row;
- int rows;
- int t;
- int uid=1;
- char query[128];
- char buff[1024]={0};
- memset(query,0,128);
- sprintf(query,"select msg from offlinemsg where uid=%d",uid);
- mysql_init(&mysql);
- if ( !mysql_real_connect(&mysql,DB_HOST, DB_USERNAME, DB_PWD, DB_USERDB,0,NULL,0) )
- printf( "Error connecting to database: %s\n",mysql_error(&mysql));
- t = mysql_real_query(&mysql,query,(unsigned int)strlen(query));
- if( t )
- printf("Error making query: %s\n",mysql_error(&mysql));
- res = mysql_store_result(&mysql);
- row = mysql_fetch_row(res);
- rows=(int)mysql_num_rows(res);
- printf("rows=%d\n",rows);
- int n=0;
- for(n;n<rows;n++)
- printf("%s\n",row[n]);
- mysql_free_result(res);
复制代码 可是结果确是:
第一行显示正确,后面显示乱码,类似“id?? der="Bin???? ""
因该不是字符集的问题吧 我都没有用中文 |
|