将msyql设置中文支持
时间:2006-08-01 来源:lilinbinglinux
1. 需要把Table的Type设置成为MyISAM而不是InnoDB。
2. 将Charecter设置成为utf8
就象这样:
create table samples (
id int not null auto_increment,
foo varchar(100) not null,
bar text not null,
primary key (id)
) Type=MyISAM CHARACTER SET utf8;
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://
localhost/test?user=root&password=root&useUnicode=true&characterEncoding=utf8");
2. 将Charecter设置成为utf8
就象这样:
create table samples (
id int not null auto_increment,
foo varchar(100) not null,
bar text not null,
primary key (id)
) Type=MyISAM CHARACTER SET utf8;
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://
localhost/test?user=root&password=root&useUnicode=true&characterEncoding=utf8");
相关阅读 更多 +