问题1:如何查看数据库的创建信息,并把数据库的字符集改为gbk,还有字符序在哪儿看。
我用了set names gbk
问题2
create table staff(
sno char(5) primary key,
sname char(20)not null,
ssex char(2) check(ssex='男' or ssex='女'),
sbirthday date,
saddress char(20),
stel char(15)UNIQUE,
cno char(15),
bno char(10),
foreign key (cno) references card(cno),
foreign key (bno) references business(bno)
);
0 row(s) affected, 2 warning(s): 1300 Invalid gbk character string: 'B7' 1300 Invalid gbk character string: 'B3'
表好像建出来了