MFC 用mysql c API讀寫database中的中文字總是亂碼....

frankyhui

MFC 用mysql c API讀寫database中的中文字總是亂碼....如何解決?

char* CStringToChar(CString str){// 把char轉成CString
  char id[MAX_PATH]=;
  int len;
  char *ptr;

  len = WideCharToMultiByte(CP_ACP, 0, str, -1, NULL, 0, NULL, NULL);
  ptr = new char [len*5];
  ZeroMemory(ptr,len * 5);
  WideCharToMultiByte(CP_ACP, 0, str, -1, ptr, len * 5, NULL, NULL);
  memcpy(id,ptr,sizeof(ptr)*5);


  return id;
}


sprintf(query,SET NAMES utf8);
mysql_query(mysql,query); // set utf8
..........
..........
..........
str=CharToCString(row[1]); // get the chinese name...
GetDlgItem(IDC_EDIT2)-SetWindowTextW(str);//show the chinese name , but....