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 , 'ÄãºÃ£¬ÎÒÊÇ¿¡¡£'
Ïà¹ØÎÊ´ð£º
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url) ²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È« Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
ĿǰÔÚÎ人ÕÒ¹¤×÷ ·¢Ïִ󲿷ֹ«Ë¾ÎÞÍâºõÁ½ÖÖ Ò»ÖÖÊǸãÍâ°üµÄ ÒªÓÃzend,cakephpµÈÍâ¹ú¿ò¼Ü »¹ÒªÊìϤÍâ¹ú¿ªÔ´ÏµÍ³ Ò»ÖÖ¹úÄÚµÄ ÎÞÍâºõ dedecms ecshop shopexÕ⼸ÖÖ¸ÄÕ¾µã ÓеĹ«Ë¾ÉõÖÁÄÃһЩ¸üСµÄϵͳ¸ ......
String sqlCount="select count(*) from usertable where username='"+ userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡ Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
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 ......