c++中关于SQLite中文乱码的解决方法

在使用SQLite的过程中（c++），如果创建一个表，如果SQL语句中包含中文字符，就会报错；如果是从数据库表中查询数据，如果数据库表中的某些字段为中文，查询结果也不能正常显示，出现这种情况的原因是因为SQLite的编码与工程的编码不一致造成的。

Sqlite的编码默认为UTF-8编码，而vc++工程中所编写的SQL语句,可能是Unciode或者ASCII码，特别是ASCII码，如果不进行转换，写入数据库以及从数据库中读出的数，都会是乱码（只针对中文字符），因此，本文主要写一下各种编码下的编码转换：

 

<pre class="cpp" name="code">//将ASCII码转换为UTF8编码
void ASCIIToUTF8(char cACSII[]  , char cUTF8[] ) 
{
	//先将ASCII码转换为Unicode编码
	int nlen= MultiByteToWideChar(CP_ACP,0,cACSII,-1,NULL,NULL);
	wchar_t *pUnicode = new wchar_t[SQL_MAX_LENTH];
	memset(pUnicode,0,nlen*sizeof(wchar_t));
	MultiByteToWideChar(CP_ACP,0,cACSII,-1,(LPWSTR)pUnicode,nlen);
	wstring wsUnicode = pUnicode ;
	//将Unicode编码转换为UTF-8编码
	nlen = WideCharToMultiByte(CP_UTF8,0,wsUnicode.c_str(),-1,NULL,0,NULL,NULL);
	WideCharToMultiByte(CP_UTF8,0,wsUnicode.c_str(),-1,cUTF8,nlen,NULL,NULL);
}

 

//将UTF-8编码转换为ASCII编码
void UTF8ToASCII(char *cUTF8 , char ASCII[])
{
	string str = cUTF8 ;
	//先将UTF8编码转换为Unicode编码
	int nLen = MultiByteToWideChar(CP_UTF8,0,str.c_str(),-1,NULL,0);
	wchar_t *pwcUnicode = new wchar_t[nLen] ;
	memset(pwcUnicode,0,nLen*sizeof(wchar_t));
	MultiByteToWideChar(CP_UTF8,0,str.c_str(),-1,(LPWSTR)pwcUnicode,nLen);
	//将Unicode编码转换为ASCII编码
	nLen = WideCharToMultiByte(CP_ACP,0,pwcUnicode,-1,NULL,0,NULL,NULL);
	WideCharToMultiByte(CP_ACP,0,pwcUnicode,-1,ASCII,nLen,NULL,NULL);
}

 

//将ASCII编码转换为Unicode编码
void ASCIIToUnicode(char cASCII[],wchar_t wcUnicode[])
{
	int nlen= MultiByteToWideChar(CP_ACP,0,cASCII,-1,NULL,NULL);
	MultiByteToWideChar(CP_ACP,0,cASCII,-1,(LPWSTR)wcUnicode,nlen);
}

 

//将Unicode编码转换为UTF-8编码
void UnicodeToUTF8(wchar_t wcUnicode[] , char cUTF8[] )
{
	wstring wsUnicode = wcUnicode ;
	int nLen =  WideCharToMultiByte(CP_UTF8,0,wsUnicode.c_str(),-1,NULL,0,NULL,NULL);
	WideCharToMultiByte(CP_UTF8,0,wsUnicode.c_str(),-1,cUTF8,nLen,NULL,NULL);
}

 

//将UTF-8编码转换为Unicode编码
void UTF8ToUnicode(char *cUTF8 , wchar_t wcUnicode[])
{
	string sUTF8 = cUTF8 ;
	int nLen = MultiByteToWideChar(CP_UTF8,0,sUTF8.c_str(),-1,NULL,0);
	MultiByteToWideChar(CP_UTF8,0,sUTF8.c_str(),-1,(LPWSTR)wcUnicode,nLen);
}

 

//将Unicode编码转换为ASCII编码
void UnicodeToUTF8(wchar_t wcUnicode[],char cASCII[])
{
	int nLen = WideCharToMultiByte(CP_ACP,0,wcUnicode,-1,NULL,0,NULL,NULL);
	WideCharToMultiByte(CP_ACP,0,wcUnicode,-1,cASCII,nLen,NULL,NULL);
}