C++往mysql中插入中文字符

1 将数据库得字符编码设置成utf-8

更改数据库的默认字符集：alter database xxx charset=utf8

2 在C/C++使用API连接到mysql数据库时，需要在连接后设置字符集，调用API函数

 mysql_set_character_set(&m_mysql, "utf8")；

MYSQL ceshi;
mysql_init(&ceshi);
mysql_real_connect(&ceshi, "127.0.0.1", "root", "798362qw", "thincovergold", 3306, NULL, 0);
mysql_set_character_set(&ceshi, "utf8");

3 代码中字符由GB2312 转换为utf-8

char* G2U(const char* gb2312)
{
	int len = MultiByteToWideChar(CP_ACP, 0, gb2312, -1, NULL, 0);
	wchar_t* wstr = new wchar_t[len + 1];
	memset(wstr, 0, len + 1);
	MultiByteToWideChar(CP_ACP, 0, gb2312, -1, wstr, len);
	len = WideCharToMultiByte(CP_UTF8, 0, wstr, -1, NULL, 0, NULL, NULL);
	char* str = new char[len + 1];
	memset(str, 0, len + 1);
	WideCharToMultiByte(CP_UTF8, 0, wstr, -1, str, len, NULL, NULL);
	if (wstr) delete[] wstr;
	return str;
}

const char *a = "insert into picture(Time,Status,Address)values('2018年11月23日10时28分57秒404毫秒',0,\
		'C:\\\\Users\\\\dyf01\\\\Desktop\\\\NGsave\\\\NG2018年11月23日10时28分57秒404毫秒.bmp')"	;

char *c = G2U(a);

 

完整代码如下：

#include "stdafx.h"
#include"mysql.h"
#include<iostream>

char* G2U(const char* gb2312)
{
	int len = MultiByteToWideChar(CP_ACP, 0, gb2312, -1, NULL, 0);
	wchar_t* wstr = new wchar_t[len + 1];
	memset(wstr, 0, len + 1);
	MultiByteToWideChar(CP_ACP, 0, gb2312, -1, wstr, len);
	len = WideCharToMultiByte(CP_UTF8, 0, wstr, -1, NULL, 0, NULL, NULL);
	char* str = new char[len + 1];
	memset(str, 0, len + 1);
	WideCharToMultiByte(CP_UTF8, 0, wstr, -1, str, len, NULL, NULL);
	if (wstr) delete[] wstr;
	return str;
}

int main()
{
	MYSQL ceshi;
	mysql_init(&ceshi);
	mysql_real_connect(&ceshi, "127.0.0.1", "root", "798362qw", "thincovergold", 3306, NULL, 0);
	mysql_set_character_set(&ceshi, "utf8");

    const char *a = "insert into picture(Time,Status,Address)values('2018年11月23日10时28分57秒404毫秒',0,\
		'C:\\\\Users\\\\dyf01\\\\Desktop\\\\NGsave\\\\NG2018年11月23日10时28分57秒404毫秒.bmp')"	;

	char *c = G2U(a);

	mysql_query(&ceshi, c);

    return 0;
}