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,cakephpµÈÍâ¹ú¿ò¼Ü »¹ÒªÊìϤÍâ¹ú¿ªÔ´ÏµÍ³ Ò»ÖÖ¹úÄÚµÄ ÎÞÍâºõ dedecms ecshop shopexÕ⼸ÖÖ¸ÄÕ¾µã ÓеĹ«Ë¾ÉõÖÁÄÃһЩ¸üСµÄϵͳ¸ ......
ʹÓÃÍøÉ쵀 phpexcelreader À࣬½«ÐéÄâ»úÄÚ´æµ÷ÕûÖµ1024M£¬excelÌå»ýΪ224M£¬ÓÃphpexcelreader¶ÁÈ¡µÄʱºòÄÚ´æ¸ù±¾²»¹»Óã¬Çë½Ì¸÷λÓÐʲôºÃµÄ·½·¨¶ÁÈ¡ÕâÖÖ´óÌå»ýµÄ excel ÎʼÛô£¿ excelÌå»ýΪ224M ·þÁË¡£¡£¡£ ......
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 ΪʲôÕâ¸ö³ÌÐòÎÞ·¨ÊµÏÖÀÛ¼ÓЧ¹û / ......
phpÖÐÈçºÎÊä³öǧ·Öλ·Ö¸ô·û¡£¡£¡£¡£¡£ number_format PHP code: //ÊÇÕâÖÖЧ¹û°É£¿ echo number_format(123123123, 2, '.', ','); //½á¹ûÊä³ö123,123,123.00 2ÊÇСÊýµãºóλÊý£¬µÚÈý¸ö²ÎÊýÊÇСÊýµã·Ö¸ô·û ......
ÎÒÓÃphpÎļþÉÏ´« ʹÓÃmove_upload_file()£¬ Ò»ÉÏ´«Îļþ¾Í³ö´íÁË£¬ ³ö´íµÄÐÅÏ¢ÊÇ Warning: move_uploaded_file(F:\Server\www\): failed to open stream: Permission denied in F:\Server\www\eoool\finish\uploa ......