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

¹ØÓÚmysqlдÈëÖÐÎijöÏÖÂÒÂëµÄÎÊÌâ - PHP / »ù´¡±à³Ì

Çë½ÌÎÊÌ⣺
mysqlÊÇutf-8ÐÎʽ£¬ÎÒÔÚ±àÐ´ÍøÒ³´úÂëʱÓõÄÊÇgb2312£¬ÇëÎÊÈçºÎÏòÊý¾Ý¿âдÈëÖÐÎĺÍÏòÒ³ÃæÊä³öÖÐÎĵÄʱºò£¬ÊÇÕý³£µÄ£¬¶ø²»»á³öÏÖÂÒÂë¡£
½¨ÒéÄãǰ̨ºÍºǫ́±£³Ö±àÂëÒ»ÖÂ
Êý¾Ý¿âдÈëÖÐÎÄ mysql_query("set names utf8");
ÏòÒ³ÃæÊä³öÖÐÎÄ <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

ÄãÕâ¸öµØ·½¿ÉÒÔʹÓÃiconv("UTF-8","GB2312",$str); ת»»Ò»ÏÂ

mysql_query("set names 'utf8'");

ÒýÓÃ
½¨ÒéÄãǰ̨ºÍºǫ́±£³Ö±àÂëÒ»ÖÂ
Êý¾Ý¿âдÈëÖÐÎÄ mysql_query("set names utf8");
ÏòÒ³ÃæÊä³öÖÐÎÄ <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

ÄãÕâ¸öµØ·½¿ÉÒÔʹÓÃiconv("UTF-8","GB2312",$str); ת»»Ò»ÏÂ

up

mb_convert_encodingÒ²¿ÉÒÔ±àÂëת»»

ÒýÓÃ
½¨ÒéÄãǰ̨ºÍºǫ́±£³Ö±àÂëÒ»ÖÂ
Êý¾Ý¿âдÈëÖÐÎÄ mysql_query("set names utf8");
ÏòÒ³ÃæÊä³öÖÐÎÄ <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

ÄãÕâ¸öµØ·½¿ÉÒÔʹÓÃiconv("UTF-8","GB2312",$str); ת»»Ò»ÏÂ
+

Æä實°´ÕÕµÀÀí來說 ÊDz»會亂碼µÄ...

Òò為utf-8µÄ範圍´ó過gb2312

µ«ÊǺÜ遺º¶mysql沒ÓÐutf-8
Ö»ÓÐutf8...兩ÕßÊÇÓвî別µÄ...
{{-


Ïà¹ØÎÊ´ð£º

mysqlÊý¾Ý¿â - Java / JavaÏà¹Ø

CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
  (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......

ÎÊÒ»¸öPHPºÍsmartyµÄÈÕÆÚÎÊÌâ - PHP / »ù´¡±à³Ì

index.phpÄÚÈÝ£º
  $smarty->assign('name',strtotime('-0'));
  $smarty->display("index.html");
index.htmlÄÚÈÝ£º
{$name|date_format:'%Y-%m-%d'}<hr>
{$ ......

mysql×Ö¶ÎÌáÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......

mysqlÎÊÌ⣡ - Java / Java SE

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

PHP+MYSQLÊý¾Ý¼¯´¦Àí - PHP / »ù´¡±à³Ì

1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ