Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 , 'ÄãºÃ£¬ÎÒÊÇ¿¡¡£'


Ïà¹ØÎÊ´ð£º

php »ñÈ¡Ò³ÃæÄÚÈÝ - PHP / »ù´¡±à³Ì

Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......

ÕÒ¹¤×÷ºÍ¶Ô¸ÕѧPHPµÄÅóÓѵÄÖÒ¸æ - PHP / ¿ªÔ´×ÊÔ´

ĿǰÔÚÎ人ÕÒ¹¤×÷  
·¢Ïִ󲿷ֹ«Ë¾ÎÞÍâºõÁ½ÖÖ
Ò»ÖÖÊǸãÍâ°üµÄ ÒªÓÃzend,cakephpµÈÍâ¹ú¿ò¼Ü
»¹ÒªÊìϤÍâ¹ú¿ªÔ´ÏµÍ³
Ò»ÖÖ¹úÄÚµÄ ÎÞÍâºõ dedecms ecshop shopexÕ⼸ÖÖ¸ÄÕ¾µã ÓеĹ«Ë¾ÉõÖÁÄÃһЩ¸üСµÄϵͳ¸ ......

mysqlÎÊÌ⣡ - Java / Java SE

String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......

phpÁª½Ó¶à¸öÊý¾Ý¿âµÄÎÊÌâ

mssql_select_db("f1",mssql_connect("localhost","sa","sa"));
mssql_select_db("f2",mssql_connect("192.168.0.1","sa","sa") ......

mysqlÍâ¼ü - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÎÒÓõÄÊÇmysql6.0Ϊʲôһ´´½¨Á½¸ö±íÕâ¼äÓÃÍâ¼üÀ´Á¬½Óʱ¾Í˵´´½¨²»ÁË£ºcan"nt create table ...
ÄãµÄÓï¾äÊÇʲô£¿ÄãµÄ±íÊÇʲô´æ´¢ÒýÇæ£¿ Èç¹ûÊÇmyisam Ôò²»Ö§³ÖÍâ¼ü£¬ÄãÐèÒª°Ñ±í¸ÄΪinndb

貼³öSQL&# ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ