1. MySQL在navicat中text类型不显示问题

1. 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;

正常显示