简明现代魔法 -> 数据库技术 -> MySQL数据库中文乱码解决方案
MySQL数据库中文乱码解决方案
2009-08-27
DEFAULT CHARSET=utf8;
在建立数据库时配置好字符集,create database testxxx default charset=utf8
建表时配置字符集。
CREATE TABLE `t_agent` (
`ID` smallint(5) NOT NULL
) DEFAULT CHARSET=utf8 ;
之前的3个数据表可以改写成这样
create table rap2009
(
rapvisitorid int unsigned not null auto_increment primary key,
name varchar(50) not null,
companyname varchar(100) not null,
position varchar(30) not null,
address varchar(120) not null,
postcode varchar(20) not null,
tel varchar(20) not null,
fax varchar(20),
email varchar(30) not null,
website varchar(50)
)DEFAULT CHARSET=utf8;
create table premax2009
(
premaxvisitorid int unsigned not null auto_increment primary key,
name varchar(50) not null,
companyname varchar(100) not null,
position varchar(30) not null,
address varchar(120) not null,
postcode varchar(20) not null,
tel varchar(20) not null,
fax varchar(20),
email varchar(30) not null,
website varchar(50)
)DEFAULT CHARSET=utf8;
create table beernight
(
beernightvisitorid int unsigned not null auto_increment primary key,
name varchar(50) not null,
companyname varchar(100) not null,
position varchar(30) not null,
address varchar(120) not null,
postcode varchar(20) not null,
tel varchar(20) not null,
fax varchar(20),
email varchar(30) not null,
website varchar(50)
)DEFAULT CHARSET=utf8;