Ruby on Rails 2.2.3 + Mysql 5.0 ½â¾öGBK±àÂëÎÊÌâ

 Ruby on Rails 2.2.3  + Mysql 5.0 ½â¾öGBK±àÂëÎÊÌâ
                
1¡¢ruby1.8.6+raile2.2.3+(Mysql 5.0 GBK±àÂë) £»
2¡¢¹¤³ÌÉèÖÃ
 ¹¤³ÌĿ¼\app\controllers\appliction.rb
#¼ÓÈëÒÔÏ´úÂ룬λÖÃËæ±ã
 before_filter :configure_charsets
  def configure_charsets
       response.headers["Content-Type"] = "text/html; charset=GBK "
   end
#»ò¼ÓÈëÏÂÃæµÄ´úÂëÒ²ÐУ¬²î²»¶à
 before_filter :set_charset 
  #ÉèÖÃ×Ö·û¼¯
   def set_charset
     headers["Content-Type"] = "text/html; charset=GBK"
    response.headers["Content-Type"] = "text/html; charset=GBK"
     suppress(ActiveRecord::StatementInvalid) do
     ActiveRecord::Base.connection.execute 'SET NAMES GBK'
     end
   end
3¡¢ÐÞ¸Ähtml.erbÎļþ´úÂë
 ¹¤³ÌĿ¼\app\viewsËùÓÐÎļþ¿ªÍ·¼ÓÉÏÈçÏÂÓï¾ä,ÈÃä¯ÀÀÆ÷ÒÔGBK»òÕßgb2312½âÊÍHTML:
 <meta http-equiv="content-type" content="text/html;charset=GBK" />
4¡¢rails»·¾³ÉèÖÃ(ÕâÒ»²½ÉèÖúÃÏñ²»×öÒ²ÐÐ)
 \ruby\lib\ruby\gems\1.8\gems\rails-2.2.3\environments\enviroment.rb
#¼ÓÈë
 $KCODE="GBK"
 ActionController::Base.default_charset=( "GBK ")
5¡¢railsÊý¾Ý¿âÅäÖÃ
 ¹¤³ÌĿ¼\config\database.yml
 development:
   adapter: mysql
 encoding: gbk
 database: blog_development#Êý¾Ý¿âÃû×Ö×Ô¼ºÐ´
 username: root
 password:
 host: localhost
6¡¢MysqlÈçºÎÉèÖÃΪGBK£º
(1)ÔÚÎļþ \MySQL Server 5.0\my.iniÖÐ
#ÕÒµ½Á½´¦
 default-character-set=latin1 
#¸ÄΪ
 default-character-set=gbk
(2)
#ÕÒµ½×Ô¼º´´½¨µÄÊý¾Ý¿âĿ¼
 \MySQL Server 5.0\data\Êý¾Ý¿âĿ¼\db.opt
#ÐÞ¸ÄΪÈçÏ£º
 default-character-set=gbk default-collation=gbk_chinese_ci
(3) ÔÚÃüÁîÐпÉÒԲ鿴ÉèÖÃÊÇ·ñÕýÈ· £º
 show variables like 'character_set_%';
 show variable