Mysql UTF8 ½â¾öÂÒÂë
1£¬ÉèÖÃmysqlĬÈϱàÂë
Ê×ÏȲéѯһÏÂshow variables like 'character%';
È·¶¨ËùÓеÄcharacter¶¼ÉèÖóÉutf-8
²Î¿¼ http://www.diybl.com/course/7_databases/mysql/myxl/20081127/152726.html
mysql>show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
2£¬
a) ÉèÖÃwebÈÝÆ÷µÄ±àÂë¸ñʽ¡£ÎªÄãµÄservletµÄdoGet»òdoPost·½·¨¿ªÊ¼´¦¼ÓÈëÈçÏ´úÂ룺
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
b) Ϊÿ¸öjspÒ³ÃæÖ¸¶¨Æä±àÂë¸ñʽ¡£<%@ page pageEncoding="utf-8"%>
c) ÔÚÁ¬½ÓÊý¾Ý¿âÓõÄURLºó¼ÓÈ룺useUnicode=true;characterEncoding=utf-8¡¡È磺
¡¡¡¡ url="jdbc:mysql:///db1?useUnicode=true&characterEncoding=utf-8"£¬
Èç¹ûÊÇxmlÎļþÖÐ url="jdbc:mysql:///db1?useUnicode=true&characterEncoding=utf-8"£¬
3,
Èç¹û»¹³öÏÖÂÒÂ룬ÔòÓпÉÄÜÊÇ ±íÖеÄ×Ö¶Î µÄ±àÂë²»ÊÇutf-8;
Èç¹û³öÏÖÂÒÂëµÄ±íÊÇ book
mysql> show create table book;
+--------------------------+----------------------------+
| Table | Create Table|
+--------------------------+----------------------------+
|book | create table 'book'(
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'bookname' varchar(45) CHARACTER SET latin1 NOT NULL,
'source' varc
Ïà¹ØÎĵµ£º
Èç¹ûÄãÊǸöÈü³µÊÖ²¢ÇÒ°´Ò»Ï°´Å¥¾ÍÄܹ»Á¢¼´¸ü»»ÒýÇæ¶ø²»ÐèÒª°Ñ³µ¿ªµ½³µ¿âÀïÈ¥»»£¬ÄÇ»áÊÇÔõô¸Ð¾õÄØ£¿MySQLÊý¾Ý¿âΪ¿ª·¢ÈËÔ±Ëù×öµÄ¾ÍºÃÏñÊǰ´°´Å¥»»ÒýÇæ£»ËüÈÃÄãÑ¡ÔñÊý¾Ý¿âÒýÇæ£¬²¢¸øÄãÒ»Ìõ¼òµ¥µÄ;¾¶À´Çл»Ëü¡£
MySQL µÄ×Ô´øÒýÇæ¿Ï¶¨Êǹ»ÓÃÁË£¬µ«ÊÇÔÚÓÐЩÇé¿öÏ£¬ÆäËûµÄÒýÇæ¿ÉÄÜÒª±ÈÊÖÍ·ËùÓøüÊʺÏÍê³ÉÈÎÎñ¡£Èç¹ûÔ¸Ò ......
1¡¢ÔÚmysql Êý¾Ý¿âÖУ¬“2009-09-15 00£º00£º00”ת»¯ÎªÁÐΪ³¤ÕûÐ͵ĺ¯Êý£º
select unix_timstamp("2009-09-15 00£º00£º00")*1000,
ÕâÀïҪעÒ⣬mysqlÊý¾Ý¿âÖеij¤ÕûÐÍ£¬±ÈjavaÖеij¤ÕûÐÍÉÙÁËÃëºóÃæµÄºÁÃëÊý£¬ËùÒÔÒª³ËÒÔ1000£¬ÕâÑùÖ»Óм¸ºÁÃëÖ®²î
2¡¢ÔÚmysqlÊý¾Ý¿âÖУ¬“1252999488000”£ ......
MysqlµÄÓα꾿¾¹ÔõôÓÖӳÈպɻ¨±ðÑùºì
Mysql´Ó5.0¿ªÊ¼Ö§³Ö´æ´¢¹ý³ÌºÍtrigger£¬¸øÎÒÃÇϲ»¶ÓÃmysqlµÄÅóÓÑÃǸüϲ»¶mysqlµÄÀíÓÉÁË£¬Óï·¨
ÉϺÍPL/SQLÓвî±ð£¬²»¹ý¸ã¹ý±à³ÌµÄÈ˶¼ÖªµÀ£¬Óï·¨²»ÊÇÎÊÌ⣬¹Ø¼üÊÇ˼Ï룬´óÖÂÁ˽âÓï·¨ºó£¬¾Í´Ó
±äÁ¿¶¨Ò壬ѻ·£¬Åжϣ¬Óα꣬Òì³£´¦ÀíÕâ¸ö¼¸¸ö·½ÃæÏêϸѧϰÁË¡£¹ØÓÚÓαêµÄÓ÷¨M ......
£©MySql ÖÐÎÄÍø£ºhttp://imysql.cn/onlinedoc
£©MySQL ÖÐÎÄÉçÇø £ºhttp://www.mysql.net.cn/
£©MySql °Ù¶È°Ù¿Æ£ºhttp://baike.baidu.com/view/24816.htm
²Î¿¼×ÊÁÏ£º
MySql°æ±¾¹¹¼Ü¼°Ë÷ÒýÎļþ½éÉÜ
Linux·þÎñÆ÷ÅäÖ÷½°¸MySQL
WinodwsÏÂIIS/Apache PHP MySQLµÄ°²×°ÅäÖÃ
³õѧMySQLÄÄЩÐèÒªÄãÖªµÀ& ......
Íü¼ÇMySQL ROOTÃÜÂëÊÇÔÚMySQLʹÓÃÖкܳ£¼ûµÄÎÊÌ⣬¿ÉÊÇÓкܶàÅóÓѲ¢²»»áÖØÖÃROOTÃÜÂ룬Äǽпడ£¬ÎÒÓÐÉîÓид¥£¬ÌØÐ´´ËÎÄÕÂÓë´ó¼Ò½»Á÷£º
1¡¢±à¼MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL_installdir%\my.ini
//Ò»°ãÔÚMySQL°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQLµÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf ......