منتديات phpBBArabia

كود: تحديد الكل

General Error
SQL ERROR [ mysqli ]

Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' [1267]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

كود: تحديد الكل

    General Error
    SQL ERROR [ mysqli ]

    Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' [1267]

    An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

كود: تحديد الكل

utf8_unicode_ci

كود: تحديد الكل

utf8_clean_string

كود: تحديد الكل

function utf8_clean_string($text)
{
	global $phpbb_root_path, $phpEx;

	static $homographs = array();
	if (empty($homographs))
	{
		$homographs = include($phpbb_root_path . 'includes/utf/data/confusables.' . $phpEx);
	}

	$text = utf8_case_fold_nfkc($text);
	$text = strtr($text, $homographs);
	// Other control characters
	$text = preg_replace('#(?:[\x00-\x1F\x7F]+|(?:\xC2[\x80-\x9F])+)#', '', $text);

	// we need to reduce multiple spaces to a single one
	$text = preg_replace('# {2,}#', ' ', $text);

	// we can use trim here as all the other space characters should have been turned
	// into normal ASCII spaces by now
	return trim($text);
}

كود: تحديد الكل

    ALTER DATABASE [db] COLLATE utf8_general_ci;
    ALTER TABLE [tables] COLLATE utf8_general_ci;