create table api_mt_100
(
AUTO_SN bigint unsigned not null AUTO_INCREMENT,
SM_ID decimal(8,0) unsigned not null default 0,
SRC_ID decimal(8,0) not null default 0,
MOBILES text not null,
CONTENT text not null,
IS_WAP tinyint not null default 0,
URL varchar(110),
SEND_TIME datetime,
SM_TYPE tinyint(1) not null default 0,
MSG_FMT int(11) not null default 0,
TP_PID tinyint(1) not null default 0,
TP_UDHI tinyint(1) default 0,
FEE_TERMINAL_ID varchar(10),
FEE_TYPE varchar(10),
FEE_CODE varchar(10),
FEE_USER_TYPE int(11) not null default 0,
primary key (AUTO_SN)
)DEFAULT CHARSET=gbk;
2.在配置数据源的url属性时候,设置为utf-8格式:
jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8
分享到:
2011-02-21 12:48
浏览 2235
分类:数据库
评论