MySQL

//111

CString strName(_T("1234")), strSex(_T("11")), strSQL;
mysql_query(m_pMySQL, "set names gb2312;");//gbk    ERROR_SUCCESS;
strSQL.Format(_T("insert into user(id,name,sex) values(\'%d\',\'%s\',\'%s\')"), id, strName, strSex);//注意一定要写在一行，而且必须要有\'\'
USES_CONVERSION;
char * pp = T2A(strSQL);
int i;
if (i = mysql_real_query(m_pMySQL, pp, (UINT)strSQL.GetLength()), i != 0){
    MessageBox(_T("增添失败"));
}

//222

CString strName(_T("1234")), strSex(_T("混沌")), strSQL;
mysql_query(m_pMySQL, "set names gb2312;");//gbk    ERROR_SUCCESS;
strSQL.Format(_T("insert into user(id,name,sex) values(\'%d\',\'%s\',\'%s\')"), id, strName, strSex);//注意一定要写在一行，而且必须要有\'\'
USES_CONVERSION;
char * pp = T2A(strSQL);
int i;
if (i = mysql_real_query(m_pMySQL, pp, (UINT)strSQL.GetLength()+2), i != 0){
    MessageBox(_T("增添失败"));
}

This ok!

if (mysql_real_query(m_pMySQL, pSql, strlen(pSql)) != 0){
        MessageBox(_T("增添失败"));
    }