Hi,someone know something about this sysser and code ?
Sysser :
SYSERR: Sep 17 10:14:39 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin2_general_ci,COERCIBLE) for operation '='
query: SELECT `empire` FROM player.player_index INNER JOIN player.player ON player.player.account_id = player.player_index.id WHERE player.player.`name` = 'yœ•¥'
Function :
std::string CInputMain::GetEmpireFlag(const char* c_pszName)
{
char newName[CHARACTER_NAME_MAX_LEN+1];
DBManager::instance().EscapeString(newName, sizeof(newName), c_pszName, sizeof(c_pszName));
std::auto_ptr<SQLMsg> pMsg(DBManager::instance().DirectQuery("SELECT `empire` FROM player.player_index INNER JOIN player.player ON player.player.account_id = player.player_index.id WHERE player.player.`name` = '%s'", newName));
MYSQL_ROW row = mysql_fetch_row(pMsg->Get()->pSQLResult);
int iEmpireIndex = 0;
if (pMsg->Get()->uiNumRows)
{
str_to_number(iEmpireIndex, row[0]);
return ConvertEmpireIndexToStr(iEmpireIndex).c_str();
}
else
{
sys_err("QUERY ERROR ON::SELECT `language` FROM account.account");
}
return "";
}