Unicode To BYTE

BYTE bUid[20], bPwd[20];

char test[20];

VARIANT rst;
VariantInit(&rst);

CString csSql = _T("SELECT * FROM UserTb;");

if(wicDB.ExecuteSQL(csSql))
{
wicDB.MoveFirst();
rst = wicDB.GetCollect(_T("uid"));

WideCharToMultiByte (CP_OEMCP, NULL, rst.bstrVal, -1, test, sizeof(test), NULL, FALSE);

memcpy(bUid, test, sizeof(bUid));

csSql.Format(_T("%s"),bUid);

//MessageBox(NULL, csSql, _T("OpenRecordset"), MB_OK);
}