مجابة مشكلة في الترميز و خاصية username_clean المزعجة

[زعيم نت]

??? ???? ?????? ??????

????? ??? ? ?????? ? ?????? ??? ???? ???? ? ??? :

???? ?? ??? ??????? ???? ??? ??????? ???? ??? ????? ?????? ?? ???? ??? ??????? ??? ???? ????? ??? ?????? :

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

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.

???? ???? ?????? ???? 3.0.5 ? ?? ??? ?????? ?? ??? ? ?? ????? ? ??? ??? ?????? ????? ???????? ?? ????? ????? ??? ??? ?? ????? ?? ???? ????? ?? ?? ??????? ?? ????? username_clean ???????? ?? ??? ????? ?????? ?? ??????? phpbb3 ???? ???? ? ???? ??? ???????

????? ???? : ??? ?????? ????? ?????? ???? ????? ??? ????? ?????? ???? ????? ?!

? ???? ? ??????? ...

[golino]

??? ??????? ?????

[زعيم نت]

??? ?????? ??????? ?? ????? ??? ??????? ? ?? ????? ??? ???? ????? ????? ???? username_clean ??? ! ??? ?? ???? ????
???? ?????? : ??? localhost ??? ????? ??? ??????? ?? ????? ??? ??????
???? ??????? ?????????: ?? ??? ?????? ?? ???
?? ?????? ???? ??? ??????? 80 ?? ???????: ??
????? ??????: 3.0.5
????? PHP : 5.2.5
??? ??? ?? ??? ?????? ? ??? ?? ????? ???? ?????: ??
?? ??? ?????? ????? ?? ????? ??? ? ???? ?: ??
?? ???? ?? ??????: ???
??? ??? ??? ? ???? ??????? ???? ???? ????: username_clean
??? ???? ??????? :

???? ?? ??? ??????? ???? ??? ??????? ???? ??? ????? ?????? ?? ???? ??? ??????? ??? ???? ????? ??? ?????? :

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

    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.

[/color]
?? ???? ????? ???? ???? ?? ???????? ?? ??? ??? ?????? ??? ???:
??? ? ?? ?????? ???????

[golino]

??? ??????? ?? phpmyadmin ???

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

utf8_unicode_ci

????? ?? ???? ?????? ?????? ???? ?????

[Garebooo]

????? ????? ?? ???? ?? ??????? ?? ?? ???? php ? phpmyadmin ??? ??????

[زعيم نت]

????? ?????? ??????

???? php

- ???? ??? ?? ??? ?? 2.11.5phpmyadmin
- ???? ?? ??? ?? ???? 1.2.0 sqlitemanager
- ?? ??? ?? 5.2.5

???? ??? ????? ??? localhost ???? ????? ???? ?? ??????? ????? ?????? ??? ???????? ??? ??? !

??? ???? ???? ???? ???? ? ...

[golino]

??? ??????? ?? phpmyadmin ???

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

utf8_unicode_ci

????? ?? ???? ?????? ?????? ???? ?????

?? ???? ??? ????

[Garebooo]

??? ??????? ?? phpmyadmin ???

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

utf8_unicode_ci

????? ?? ???? ?????? ?????? ???? ?????

?? ???? ??? ????

[زعيم نت]

??? ?????? ???????? ??? ??????? ?????? ??????

??????? ??? ?? ????? ?? ????? username_clean

???? ???? ???????? ????? ??? ??? ????

[golino]

???? ??? ??? ?????? ?? root
includes/utf/utf_tools.php
???? ?? ????? ??????? ??

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

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

[زعيم نت]

???? ??? golino ??? ??? ?????? ? ? ??? ?????? ?? ????? ??????? ??? ?? ????? ? ..!

[golino]

?? ???? ?? ??? ?? ?????? ??????? ??? ???? ??????? ??? ?????? ??????? ?? ??? ???? ????? ?
?? ????? ???? ??? ????? ?? ???? ??? ???? ??? ???????

[زعيم نت]

?? ???? ?? ??? ??? ?????? ?? ???? ??? ??????? ??? ????? ??????? ?????? ????? ??? ??????? ?????? ??????? ???????? ??? ???????? ?????????? ??? ???? ??? ??????? ???? ????? ???? ??? ?????? ????? ???? ?????? ?? ??? ??????? ?????? ???? ?? ??????? ???? ????? ?? ??? ??? ??? phpbb

[Garebooo]

??? ????? ??? ????? ?? SQL /

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

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

?? ?? ??????? ??? ?????? ???? ??? localhost ???? ???? ??? ? ?????? ?????? ???? ????? ????

?????? ??? ????? ??????? ? ???? ?? ?? ????? ??????? ?? utf8

????????

[golino]

??? ?? ????? ??? ????
???????? ?????? ????? ?? ??? ?? ?????? ???? ?? ????? ??? ?? ?? ??? ??? ??? ?? ??? ?? ??? ??? ?? ?? ?? ??? ????? ? phpbb ?? ?? ???? ???? ???????? ????? ???? ???? ????? ?????? ????? ??? ???? ???? ???? ?? ?? ???? ?? ??????? ????? ??????? ?? ????? ?? ??????? ??? ???? ??? ?? ?????? ???? ????? "???? ?? ?????? ????? ???????? ?? ?????? ???? ???? ?????? " ??????