useUnicode=true&characterEncoding=utf-8
<property name="connection.url">jdbc:mysql:///hiberate?useUnicode=true&characterEncoding=utf-8</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.username" >root</property>
<property name="connection.password">root</property>
先mysql进入:
GBK: create database test2 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
UTF8: CREATE DATABASE test2
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
create database sss character set utf8
在创建表的时候
CREATE TABLE ad_image_path
(
id
int(11) NOT NULL AUTO_INCREMENT COMMENT ‘自增主键’,
material_id
int(11) DEFAULT NULL,
image_url
varchar(255) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
AUTO_INCREMENT是指定 自增长的开始;