SET NAMES 'utf8';
SET v_length = character_length(citys);
SET citys = left(citys COLLATE utf8_bin, v_length - 1);
本段代码截取ctiys字符中的组后一个字符。
SET NAMES 'utf8';
SET v_length = character_length(citys);
SET citys = left(citys COLLATE utf8_bin, v_length - 1);
本段代码截取ctiys字符中的组后一个字符。
转载于:https://www.cnblogs.com/alexwu59/p/3671067.html