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

¼¸¸ö¹ØÓÚmysqlºÍphpµÄ×Ö·û¼¯ÎÊÌ⣬ÇóÖú

¸÷λºÃ~СµÜÔÚѧϰmysqlºÍphpµÄʱºò£¬Óöµ½¼¸¸ö×Ö·û¼¯Ïà¹ØµÄÎÊÌ⣬²»Äܽâ¾ö£¬»¹ÍûºÃÐÄÈ˴ͽ̡£
Question1£º
mysqlµÄ×Ö·û¼¯²ÎÊý£º
| character_set_client | utf8
| character_set_connection | utf8
| character_set_database | utf8
| character_set_results | utf8
| character_set_server | utf8
| character_set_system | utf8

ÔÚÕâ¸öÇé¿öÏ£¬ÎÒÓÃcmdÐÎʽ£¬
Ö´ÐУºmysql> insert into test values('ÎÒÊÇÖÐÎÄ');
»á³öÏÖ£ºERROR 1406 (22001): Data too long for column 'text' at row 1
Èç¹ûÔÚÕâ֮ǰ£¬ÏÈÖ´ÐÐmysql> set names gbk£¬Ôò¿ÉÒԳɹ¦²åÈëÖµ¡£
Ϊʲô»á³öÏÖÕâÖÖÇé¿ö£¿ÈçºÎ²ÅÄÜ×öµ½ÔÚÒÔÉÏ×Ö·û¼¯²ÎÊýµÄÌõ¼þϲ»Ö´ÐС°set names gbk¡±Ò²ÄÜÕýÈ·²åÈëÖÐÎÄ£¿

ÎÒ¸öÈËÈÏΪÊÇÕâÑùµÄ£º
cmdÃüÁîÐÐÏÂÊÇÓÃgbk±àÂëµÄ£¬¼´¡°ÎÒÊÇÖÐÎÄ¡±Ëĸö×ÖÔÚclient¶Ë²ÉÓÃgbk±àÂ룻
ÒòΪcharacter_set_client=utf8£¬ËùÒÔÔÚ´«Ïòmysqlʱ£¬mysqlÈÏΪclient¶Ë´«ÈëµÄ×Ö·û´®ÊÇutf8±àÂë(ÆäʵÊÇgbk±àÂë)£»
È»ºóÒòΪcharacter_set_connection=utf8,Óëcharacter_set_clientÒ»Ñù£¬ÔÚ±£´æÊ±¾Í²»×ªÂ룬ֱ½Ó±£´æÁËÏÂÀ´£»
×îºóÔÚ²éѯ·µ»ØÊ±£¬ÓÉÓÚcharacter_set_results=utf8£¬Óëcharacter_set_connectionÒ»Ñù£¬ËùÒÔÖ±½Ó°Ñ±£´æµÄ×Ö·û´®²»×ªÂ룬ֱ½Ó×÷Ϊutf8µÄ±àÂë·µ»Ø£»
ÕâÑù£¬±¾À´ÊÇgbk±àÂëµÄ×Ö·û´®±»cmdÃüÁîÐе±³ÉÁËutf8µÄ×Ö·û´®ÏÔʾ£¬×ÔÈ»³ÉÁËÂÒÂ룡
ÔÚÖ´ÐÐÁË¡°set names gbk¡±ºó£¬ÕâÈý¸ö²ÎÊý¶¼±»¸ÄΪÁËgbk£¬ÒÔgbk´æ£¬gbk´«Ê䣬gbkÏÔʾ£¬×ÔÈ»¾ÍÊÇÕýÈ·µÄÁË¡£

Question2:
mysqlµÄ×Ö·û¼¯²ÎÊýºÍÎÊÌâ1Ò»Ñù£¬¶¼ÊÇutf8£»phpÎļþ±àÂëΪutf8£»ä¯ÀÀÆ÷±àÂëΪutf8£»
insert.php£º
<?php&


Ïà¹ØÎÊ´ð£º

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

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

ÇëÎÊphp²ÉÓÃʲô¼ÓÃÜ·½Ê½²»±»ÆÆ½â£¿ - PHP / »ù´¡±à³Ì

zend guard¼ÓÃܵÄphpÊÇ¿ÉÒÔÆÆ½âµÄ£¬ÓÐµÄ ËµÊÇʹÓú¯Êý»ìÏý¿ÉÒÔ¸üÄÑÆÆ½âһЩ¡£ÔõôʹÓÃÄØ¡£
»òÕß´ó¼Ò¸æËßÎÒÄÄÖÖ¼ÓÃÜ·½Ê½¸ü°²È«¡£Ð»Ð»ÁË¡£
ÎÒĿǰµÄzend guard°æ±¾ÊÇ4.0.1
ÎÞ½â

ÒýÓÃ
ÎÞ½â
²»¿ÉÄܰɡ£ÔÚÍøÉϲéÁ ......

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

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

phpÈçºÎ»ñÈ¡µ±Ç°Ò³µØÖ·À¸µÄURLµØÖ· - PHP / ¿ªÔ´×ÊÔ´

¾ÍÊÇÎÒÔÚij¸öÍøÒ³²åÈëÁËÒ»¸öphpÁ´½Ó
ÎÒÏë»ñµÃÄǸöÍøÖ·µØÖ·µØÖ·À¸µÄurl¶øÇÒÒªÊä³ötxt¸ñʽ»òÆäËû¸ñʽ¡£Ó¦¸ÃÈçºÎʵÏÖ£¿£¿£¿
»¹ÓоÍÊÇдÈëµ½.txt ÎļþÀÔõôȥÅжÏÊÇ·ñÖØ¸´¡£
$_sever[request_uri]


Â¥Ö÷¸øµã·Ö ......

mysqlÎÊÌ⣡ - Java / Java SE

String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ