" PMA . PMA . ? header. ?
...?
DB PHP : PHP: mysql_query("SET character_set_client = utf8"); mysql_query("SET character_set_connection = utf8"); mysql_query("SET character_set_results = utf8");
mysql_query("SET character_set_client = utf8"); mysql_query("SET character_set_connection = utf8"); mysql_query("SET character_set_results = utf8");
HTML PHP: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <!-- @author:B100 & rril --> <html> <head> <meta http-equiv="Content-Language" content="he" /> <meta http-equiv="Content-Type" content="text/html; charset=windows-1255" /> <title> - </title> <link rel="stylesheet" href="style.css" type="text/css" /> </head> <body alt="rtl" bgcolor="#00C8FC" > <p style="font-size:12px;">.</p> <table border="0" cellpadding="0" cellspacing="0" align="center" width="850px"> <tr> <td width="70%" align="center"><img src="title.JPG" width="850px" height="176px" /></td> </tr> <tr> <td> <br />-׳׳₪׳׳ c9434b5f8fd7bf3dad16d745ac99c9f4 </td></tr> </table><form action="" method="get"> <p>name <input type="text" id="name" name="name"/><br /> pass(20) <input type="text" id="pass" name="pass" maxlength=20 /> <input type="submit" value="reg" /> </p></form> </body> </html> PHP: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <!-- @author:B100 & rril --> <html> <head> <meta http-equiv="Content-Language" content="he" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>���� ������ ������ - �����</title> <link rel="stylesheet" href="style.css" type="text/css" /> </head> <body alt="rtl" bgcolor="#00C8FC" > ����� ��� �����<p style="font-size:12px;">.</p> <table border="0" cellpadding="0" cellspacing="0" align="center" width="850px"> <tr> <td width="70%" align="center"><img src="title.JPG" width="850px" height="176px" /></td> </tr> <tr> <td> <br />- c9434b5f8fd7bf3dad16d745ac99c9f4 </td></tr> </table><form action="" method="get"> <p>name <input type="text" id="name" name="name"/><br /> pass(20) <input type="text" id="pass" name="pass" maxlength=20 /> <input type="submit" value="reg" /> </p></form> </body> </html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <!-- @author:B100 & rril --> <html> <head> <meta http-equiv="Content-Language" content="he" /> <meta http-equiv="Content-Type" content="text/html; charset=windows-1255" /> <title> - </title> <link rel="stylesheet" href="style.css" type="text/css" /> </head> <body alt="rtl" bgcolor="#00C8FC" > <p style="font-size:12px;">.</p> <table border="0" cellpadding="0" cellspacing="0" align="center" width="850px"> <tr> <td width="70%" align="center"><img src="title.JPG" width="850px" height="176px" /></td> </tr> <tr> <td> <br />-׳׳₪׳׳ c9434b5f8fd7bf3dad16d745ac99c9f4 </td></tr> </table><form action="" method="get"> <p>name <input type="text" id="name" name="name"/><br /> pass(20) <input type="text" id="pass" name="pass" maxlength=20 /> <input type="submit" value="reg" /> </p></form> </body> </html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <!-- @author:B100 & rril --> <html> <head> <meta http-equiv="Content-Language" content="he" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>���� ������ ������ - �����</title> <link rel="stylesheet" href="style.css" type="text/css" /> </head> <body alt="rtl" bgcolor="#00C8FC" > ����� ��� �����<p style="font-size:12px;">.</p> <table border="0" cellpadding="0" cellspacing="0" align="center" width="850px"> <tr> <td width="70%" align="center"><img src="title.JPG" width="850px" height="176px" /></td> </tr> <tr> <td> <br />- c9434b5f8fd7bf3dad16d745ac99c9f4 </td></tr> </table><form action="" method="get"> <p>name <input type="text" id="name" name="name"/><br /> pass(20) <input type="text" id="pass" name="pass" maxlength=20 /> <input type="submit" value="reg" /> </p></form> </body> </html>
: -mysql PHP: mysql_query("SET character_set_client = utf8"); mysql_query("SET character_set_connection = utf8"); mysql_query("SET character_set_results = utf8"); : : <meta http-equiv="Content-Type" content="text/html; charset=windows-1255" /> ? , . , '... ? CREATE TABLE, ? ? : utf-8,
<meta http-equiv="Content-Type" content="text/html; charset=windows-1255" />
. : SELECT name, id FROM admin WHERE name = '' AND pass = 'c9434b5f8fd7bf3dad16d745ac99c9f4' SQL ERROR : Illegal mix of collations (hebrew_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' ???
SELECT name, id FROM admin WHERE name = '' AND pass = 'c9434b5f8fd7bf3dad16d745ac99c9f4'
Illegal mix of collations (hebrew_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
. ? PhpMyAdmin? : , , , "Operations" , Collation utf8. , -collation . , utf .
, : SET NAMES utf8 utf8. , hebrew - utf8 . , utf8 - utf8, utf8. utf8_general_ci. . : , . .
SET NAMES utf8
UTF-8 windows-1255. .
. .
. - UTF-8
. UTF8 MySQL
UTF-8 ..
! . PHP . . GreenBerret
: utf-8 -Phpmyadmin. , -utf-8 -utf-8. ( ) -utf-8 , . , , , . PHP . , .