sqlite中文乱码问题原因分析及解决

//UTF-8转Unicode

std::wstring Utf82Unicode(const std::string& utf8string)

{

int widesize=::MultiByteToWideChar(CP_UTF8, 0, utf8string.c_str(), -1, NULL, 0);

if (widesize==ERROR_NO_UNICODE_TRANSLATION)

{

throw std::exception(“Invalid UTF-8 sequence.”);

}

if (widesize==0)

{

throw std::exception(“Error in conversion.”);

}

std::vector resultstring(widesize);

int convresult=::MultiByteToWideChar(CP_UTF8, 0, utf8string.c_str(), -1, &resultstring[0], widesize);

if (convresult !=widesize)

{

throw std::exception(“La falla!”);

}

return std::wstring(&resultstring[0]);

}

//unicode 转为 ascii

string WideByte2Acsi(wstring& wstrcode)

{

int asciisize=::WideCharToMultiByte(CP_OEMCP, 0, wstrcode.c_str(), -1, NULL, 0, NULL, NULL);

if (asciisize==ERROR_NO_UNICODE_TRANSLATION)

{

throw std::exception(“Invalid UTF-8 sequence.”);

}

if (asciisize==0)

{

throw std::exception(“Error in conversion.”);

}

std::vector resultstring(asciisize);

int convresult=::WideCharToMultiByte(CP_OEMCP, 0, wstrcode.c_str(), -1, &resultstring[0], asciisize, NULL, NULL);

if (convresult !=asciisize)

{

throw std::exception(“La falla!”);

}

return std::string(&resultstring[0]);

}

//utf-8 转 ascii

string UTF_82ASCII(string& strUtf8Code)

{

string strRet(“”);

//先把 utf8 转为 unicode

wstring wstr=Utf82Unicode(strUtf8Code);

//最后把 unicode 转为 ascii

strRet=WideByte2Acsi(wstr);

return strRet;

}

///////////////////////////////////////////////////////////////////////

//ascii 转 Unicode

wstring Acsi2WideByte(string& strascii)

{

int widesize=MultiByteToWideChar (CP_ACP, 0, (char*)strascii.c_str(), -1, NULL, 0);

if (widesize==ERROR_NO_UNICODE_TRANSLATION)

{

throw std::exception(“Invalid UTF-8 sequence.”);

}

if (widesize==0)

{

throw std::exception(“Error in conversion.”);

}

std::vector resultstring(widesize);

int convresult=MultiByteToWideChar (CP_ACP, 0, (char*)strascii.c_str(), -1, &resultstring[0], widesize);

if (convresult !=widesize)

{

throw std::exception(“La falla!”);

}

return std::wstring(&resultstring[0]);

}

//Unicode 转 Utf8

std::string Unicode2Utf8(const std::wstring& widestring)

{

int utf8size=::WideCharToMultiByte(CP_UTF8, 0, widestring.c_str(), -1, NULL, 0, NULL, NULL);

if (utf8size==0)

{

throw std::exception(“Error in conversion.”);

}

std::vector resultstring(utf8size);

int convresult=::WideCharToMultiByte(CP_UTF8, 0, widestring.c_str(), -1, &resultstring[0], utf8size, NULL, NULL);

if (convresult !=utf8size)

{

throw std::exception(“La falla!”);

}

return std::string(&resultstring[0]);

}

//ascii 转 Utf8

string ASCII2UTF_8(string& strAsciiCode)

{

string strRet(“”);

//先把 ascii 转为 unicode

wstring wstr=Acsi2WideByte(strAsciiCode);

//最后把 unicode 转为 utf8

strRet=Unicode2Utf8(wstr);

return strRet;

}