mysql utf-8ÂÒÂëÎÊÌâ - PHP / »ù´¡±à³Ì
ÔÚphpmyadminÊäÈëÊý¾Ýºó ͨ¹ýNavicat for MYSQL ´ò¿ª±íºóÓÐÊý¾ÝµÄµØ·½¶¼ÏÔʾBLOB ²¢ÇÒÔÚNavicat ÏÂÎÞ·¨²åÈëÊý¾Ý¡£ PHPÊä³öºóÂÒÂë ÔÚphpadminÖпÉÒÔ²åÈëÊý¾Ý£¬ÏÔʾÕý³£ ×¢£ºPHPÖмÓÁËheader('content-type;text/html;charset=utf-8');ÎÊÌâÒÀ¾É ÇëÎʸ÷Î»ÎªÊ²Ã´ÄØ£¿ÈçºÎ½â¾ö лл
phpmyadminÊÇÀϰ汾µÄ£¿£¿£¿ÒýÓà phpmyadminÊÇÀϰ汾µÄ£¿£¿£¿ 3.2.4 mysql_query("SET NAMES 'utf8'"); ÄØ£¿ Êý¾Ý¿â±àÂëÊÇutf8Âð£¿ÒýÓà mysql_query("SET NAMES 'utf8'"); ÄØ£¿ Êý¾Ý¿â±àÂëÊÇutf8Â𣿠Êǵġ£ ÎÒÊÇ´ÓPHPMYADMINÀï²åÈëµÄÊý¾Ý ÔÚNavicat ÀïÏÔʾBLOB £¬ÔÚPHPÀïÊä³öÏÔʾ£¿£¿£¿£¿£¿£¿ ²»ÖªµÀÔõô»ØÊ Ŷ£¬ÒÔǰÓö過這樣µÄ問題¡£²»Öª這´ú碼對ÄãÊÇ·ñÓÐ幫Öú¡£ SQL code: CREATE DATABASE `testing` ; SQL code: CREATE TABLE `testing`.`tb_test` ( `id` INT( 255 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ) ENGINE = MYISAM INSERT INTO `testing`.`tb_test` ( `id` , `name` ) VALUES ( NULL , 'ÄãºÃ£¬ÎÒÊÇ¿¡¡£'
Ïà¹ØÎÊ´ð£º
zend guard¼ÓÃܵÄphpÊÇ¿ÉÒÔÆÆ½âµÄ£¬ÓÐµÄ ËµÊÇʹÓú¯Êý»ìÏý¿ÉÒÔ¸üÄÑÆÆ½âһЩ¡£ÔõôʹÓÃÄØ¡£ »òÕß´ó¼Ò¸æËßÎÒÄÄÖÖ¼ÓÃÜ·½Ê½¸ü°²È«¡£Ð»Ð»ÁË¡£ ÎÒĿǰµÄzend guard°æ±¾ÊÇ4.0.1 ÎÞ½â ÒýÓà Î޽⠲»¿ÉÄܰɡ£ÔÚÍøÉϲéÁ ......
mssql_select_db("f1",mssql_connect("localhost","sa","sa")); mssql_select_db("f2",mssql_connect("192.168.0.1","sa","sa") ......
ÎÒÓõÄÊÇmysql6.0Ϊʲôһ´´½¨Á½¸ö±íÕâ¼äÓÃÍâ¼üÀ´Á¬½Óʱ¾Í˵´´½¨²»ÁË£ºcan"nt create table ... ÄãµÄÓï¾äÊÇʲô£¿ÄãµÄ±íÊÇʲô´æ´¢ÒýÇæ£¿ Èç¹ûÊÇmyisam Ôò²»Ö§³ÖÍâ¼ü£¬ÄãÐèÒª°Ñ±í¸ÄΪinndb 貼³öSQL ......
¼±Çó£ºÔÚphp½Å±¾ÀïÔõôµ÷ÓÃjsÎļþÀï·½·¨£¿ »òÕßÔÚjsÎļþÀïµ÷ÓÃphpÎļþдµÄseesion£¿ PHP¸ÕÈëÃÅѧϰ,ÓÑÇé¶¥Ò»¸ö ¼±Çó£ºÔÚphp½Å±¾ÀïÔõôµ÷ÓÃjsÎļþÀï·½·¨£¿ //echo '<script>alert("ok");< ......
sp ³ÌÐò delimiter // create procedure ma() begin declare i int default 0; while i<11 do set i=i+1; select i; end while; end // delimiter ; 1+2+...+9+10 ΪʲôÕâ¸ö³ÌÐòÎÞ·¨ÊµÏÖÀÛ¼ÓЧ¹û / ......