mysql4.1.2的默認字符集是latin1，latin1屬于ISO8859-1的子集(或者是一回事？毛深入研究)，寫入時需要為iso8859-1的編碼，讀出時要轉換成gbk編碼，就不會是亂碼。
Class.forName("org.gjt.mm.mysql.Driver");
String url ="jdbc:mysql://localhost/mysql";
Connection conn=DriverManager.getConnection(url,"root","root");
Statement stmt=conn.createStatement();
String a="老哈斯蒂芬";
a=new String(a.getBytes("GBK"),"iso8859-1");
stmt.executeUpdate("insert into zquan (name) value ('"+a+"')");
ResultSet rs=stmt.executeQuery("select name from zquan");
while(rs.next()){
String aaa=rs.getString(1);
System.out.println(new String(aaa.getBytes("iso8859-1"),"GB2312"));
}
posted on 2008-11-25 11:12
一凡 閱讀(871)
評論(0) 編輯 收藏 所屬分類:
DATABASE