Jump to content

Illegal mix of collations


Recommended Posts

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 "";
}

 

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.