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 , 'ÄãºÃ£¬ÎÒÊÇ¿¡¡£'
Ïà¹ØÎÊ´ð£º
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml <Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
Çë½Ì¸ßÊÖ°ï棬session_start£¨£©·ÅÔÚÍⲿµÄÎļþÓà require »ò include °üº¬½øÀ´£¬ÇëÎÊÕâÑù×öºÏÀíÂ𣿣¿´úÂëÔËÐÐÊÇÕý³£µÄ£¬ÕâÑù×öºÏÀíÂ𣿣¿Çë¸ßÊÖÖ¸µã¡£¡£¡£¡£ лл···· require »ò include ......
¼±Çó£ºÔÚ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 ΪʲôÕâ¸ö³ÌÐòÎÞ·¨ÊµÏÖÀÛ¼ÓЧ¹û / ......