- MySQL在navicat中text类型不显示问题
CREATE TABLE `test` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`msg` text COLLATE utf8_bin,
`boolean` bit(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
解决:
修改排序策略为utf8_general_ci或utf8_unicode_ci
CREATE TABLE `test` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`msg` text CHARACTER SET utf8,
`boolean` bit(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
正常显示