–
1.裝mysql5.1,沒有進行MySQL Server Instance Config Wizard配置 ,選用stand option 選項進行配置.
 進入mysql后顯示中文亂碼,插入中文亂碼 set names gb2312后解決

2.裝msyql odbc 5.1

3.裝mysql front 進行連接 字符集選gb2312 colaction 選gb2312_chinese_ci
 
在創(chuàng)建表,表字段時選用gb2312進行編碼

<%
    set conn=server.createobject(“adodb.connection”)

 connectionstring=”driver={mysql odbc 5.1 driver};database=mysql;server=localhost;uid=root;password=abc;opt=3;smt=SET NAMES ‘gb2312′”
 conn.open connectionstring
 
 set rs=server.createobject(“adodb.recordset”)
 rs.open “select * from testme”,conn,1,1
 while not rs.eof
 response.write rs(“username”)
 rs.movenext
 wend
 rs.close
 set rs=nothing
 sql=”insert into testme (username) values(‘中國’)”
 conn.execute sql
 %>

 這樣取出中文就不是亂碼啦