msyql 视图给字段自定义字符集 utf8mb4_unicode_ci

SELECT
	`z`.`id` AS `id`,
	`z`.`unit_name` AS `unit_name`,
	`u`.`resp_name` AS `resp_name`,
	`u`.`resp_email` AS `resp_email`,
	`u`.`resp_mobile` AS `resp_mobile`,
	`u`.`pcs_code` AS `pcs_code`,
	`z`.`unit_id` AS `unit_cert`,
	`z`.`created_at` AS `created_at`,
	'major' COLLATE utf8mb4_unicode_ci AS `type`,
	'重保自查' COLLATE utf8mb4_unicode_ci AS `type_txt` 
FROM
	`zip_uploads` `z`
	JOIN `basic_idc_unit` `u` ON `u`.`unit_id` = `z`.`unit_id`

给type字段增加 utf8mb4_unicode_ci 字符集