前段时间写数据存储与恢复用到了sqlite,结果遇到了一个很让人纠结的问题,那就是sqlit再对中文进行操作是出项乱码,写入是有乱码,读出来时也会有乱码。因为sqlit对应的是UTF8编码,而我们平时的字符传都是UNCOID编码和ASCII编码,而这有很大的区别,这里不做解释,
而sqlit的所有操作都是基于UTF8的,这就造成对中文乱码问题,如何向sqlite中写入中文,就首先将字符传转换成UTF8编码,而当读取的时候需要将UTF8再转换过来,下面给你两个方法
//UTF-8到GB2312的转换
char* U2G(const char* utf8)
{
int len = MultiByteToWideChar(CP_UTF8, 0, utf8, -1, NULL, 0);
wchar_t* wstr = new wchar_t[len+1];
memset(wstr, 0, len+1);
MultiByteToWideChar(CP_UTF8, 0, utf8, -1, wstr, len);
len = WideCharToMultiByte(CP_ACP, 0, wstr, -1, NULL, 0, NULL, NULL);
char* str = new char[len+1];
memset(str, 0, len+1);
WideCharToMultiByte(CP_ACP, 0, wstr, -1, str, len, NULL, NULL);
if(wstr) delete[] wstr;
return str;
}
//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;
}
具体参见http://hi.baidu.com/hxzwen/blog/item/129108ca496b4d4cb219a841.html