今天做项目,对于文本编辑器里面存取的内容,数据库用text 类型,居然爆仓了!
查了下,原来还有比text 存取大的值:
最终选用了 MEDIMTEXT 解决了遇到的这个问题。
// 测试服务器新建数据库 (第四步骤未做)
1 create database mcdjytest CHARACTER SET utf8; //已经完成
2
create table users
(
openId varChar(255) default '',
nickName varChar(255) not null primary key,
avatarUrl varChar(255) default '',
gold int(7),
sex char(1),
score int(7),
firstAid int(7),
level int(7),
redPacket varChar(255) default '',
unionId varChar(255) default ''
) ;
3
create table redPacket(
nickName varChar(255) not null primary key,
nRedPacket float(5, 2),
giftInfor mediumtext,
upperLimitForRob int(7),
friendListForRob mediumtext,
robbedListForRob mediumtext,
avatarUrl varChar(255),
putOutCount int(11),
dayGetCount varChar(255),
loginRedPacket varChar(255),
unionId varChar(255),
zhuanPanRedPacket varChar(255)
); //DEFAULT CHARSET= utf8mb4;
4 https://blog.csdn.net/woslx/article/details/49685111
ALTER DATABASE utf8 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE redPacket CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;