ALTER TABLE `assets` CHANGE `ticket_no` `ticket_no` VARCHAR(145) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;