SSH+MySQL¿ª·¢ÖеÄÖÐÎÄÂÒÂëÎÊÌâ
Ò»¡¢±íµ¥Ìá½»ÂÒÂë½â¾ö·½·¨
±íµ¥Öк¬ÓÐÖÐÎÄÌá½»ÂÒÂ룬¶ÔÓÚ×ÖĸºÍÊý×ÖÔò²»»áÂÒÂ룬ÎÒÑ¡ÓõÄ×Ö·û¼¯utf-8(ÒÔÏÂͬ)¡£
1¡¢ÔÚapache-tomcat-6.0.18\webapps\examples\WEB-INF\classes\filtersĿ¼ÏÂÕÒµ½ÎļþSetCharacterEncodingFilter.java ºÍRequestDumperFilter.javaÎļþ£¬²¢½«Æ临ÖƵ½ÏîÄ¿srcϵÄfilters°üÖС£
2¡¢ÔÚWeb.xmlÖмÓÈëfilter¡£
<filter>
<filter-name>Set Character Encoding</filter-name>
<filter-class>filters.SetCharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>utf8</param-value>
</init-param>
</filter
<filter-mapping>
<filter-name>Set Character Encoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
3¡¢ÔÚjspÒ³ÃæÖмÓÈëÁ½ÐдúÂ룺
<%@ page contentType="text/html;charset=UTF-8"%>
<meta http-equiv="contentType" content="text/html;charset=utf-8">
¶þ¡¢MySQLÊý¾Ý¿â×Ö·û¼¯½â¾ö·½·¨
1¡¢ÐÞ¸ÄMySql°²×°Ä¿Â¼ÏµÄmy.iniÎļþ
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
ÐÞ¸ÄÖ®ºó±£´æ¡£
2¡¢ÔÚMySQl¿Í»§¶ËÊäÈëÃüÁî
mysql> status ²é¿´Êý¾Ý¿â×Ö·û¼¯ÉèÖÃ
Èç¹ûÏÔʾÈçÏ£º
Server characterset: utf8
Db characterset: utf8
Client characterset:
Ïà¹ØÎĵµ£º
1.mysqlÖ÷´ÓÊý¾Ý¿âͬ²½ÎÊÌâ
ÔÚʹÓÃmysql 5.0 Ö÷´ÓÊý¾Ý¿âͬ²½Ê±Óöµ½ÎÊÌâһЩÎÊÌ⣺
ÔÚÖ÷´ÓÊý¾Ý¿âͬ²½Ê±£¬ÎÒÃÇ¿ÉÄÜ»áÑ¡ÔñÄÄЩÊý¾Ý¿âÒªÇóͬ²½£¬¶øÄÇЩÊý¾Ý¿âºöÊÓ£¬ÕâÁ½¸ö¹¦ÄÜÊÇ¿¿/etc/my.cnfÎļþÖеÄÁ½¸ö¼üÃû binlog_do_db ºÍ binlog_ignore_db À´ÊµÏÖµÄ
binlog_do_db = ÌîдÐèҪͬ²½µÄÊý¾Ý¿â£¬¶à¸öÊý¾Ý¿âÔòÓÃ&lsqu ......
1 MySQLÖ§³Öenum,ºÍsetÀàÐÍ£¬SQL Server²»Ö§³Ö
¡¡¡¡2 MySQL²»Ö§³Önchar,nvarchar,ntextÀàÐÍ
¡¡¡¡3 MySQLµÄµÝÔöÓï¾äÊÇAUTO_INCREMENT£¬¶øMS SQLÊÇidentity(1,1)
¡¡¡¡4 MS SQLĬÈϵ½´¦±í´´½¨Óï¾äµÄĬÈÏÖµ±íʾÊÇ((0)),¶øÔÚMySQLÀïÃæÊDz»ÔÊÐí´øÁ½À¨ºÅµÄ
¡¡¡¡5 MySQLÐèҪΪ±íÖ¸¶¨´æ´¢ÀàÐÍ
¡¡¡¡6 MS SQLʶ±ð·ûÊÇ[],[type]±íÊ ......
[part1] http://download.csdn.net/source/2076258
[part2] http://download.csdn.net/source/2076272
[part3] http://download.csdn.net/source/2076276
[part4] http://download.csdn.net/source/2076283
[part02-04] http://www.ytgps.com/Images/nginx.rar
±¾ÎļþÌå»ý¹ý´ó·Ö4¸ö°ü£¬php-cgi+mysql+nginx.7z ......
³õѧmysqlÎÒÒ²Åöµ½ÖÐÎÄ´æ´¢µÄÎÊÌ⣬ÒÔÏÂÊÇÎҵĽâ¾ö·½°¸£º
1.Ê×ÏÈÔÚ×Ö¶ÎÑ¡Ïîcolumn option Öн«×Ö¶Î×Ö·û¼¯column charsetÉèΪgb2312¡£
2.»¹ÐèÒªÔÚ±íÑ¡Ïîtable option ÖÐͬÑù½«charsetÉèÖÃΪgb2312.
3.×îºóÈç¹û»¹²»ÐУ¬¾ÍÔÚmysql°²×°Ä¿Â¼ÏÂÕÒµ½my.ini,ÕÒµ½ÒÔÏÂλÖãº
[mysql]
default-cha ......
Õâʱ¼äÔÚ°²×°PHPBBµÄÂÛ̳£¬·¢ÏÖÒ»¸öÎÊÌ⣬ÄǾÍÊÇÊäÈëÓû§Ãû¸úÃÜÂëºó£¬µã»÷°²×°£¬×ÜÊDZ¨ÁËÒÔϵĴíÎó£º
³ÌÐò´úÂë
ORA-28008: invalid old password
Cause: old password supplied is wrong; Hence user cannot be authenticated using old password
Action: Supply the correct old password for authenticatio ......