SET NAMES 'utf8'; SET v_length = character_length(citys); SET citys = left(citys COLLATE utf8_bin, v_length - 1);
本段代码截取ctiys字符中的组后一个字符。