mysql也能实现二元分词法

DELIMITER $$;

DROP FUNCTION IF EXISTS `radius`.`fun_split`$$ 免费网页模版下载http://www.it55.com

CREATE DEFINER=`root`@`%` FUNCTION `fun_split`(nm varchar(100)) RETURNS varchar(500) CHARSET latin1
    READS SQL DATA
BEGIN
      declare i int;
      declare rtn int;
      declare rtn1 int;
      declare sec varchar(10);
      declare rtnstr varchar(500);
          set i=1;
      set rtnstr='';
          WHILE i <length(nm) DO
      set rtn= ascii(substring(nm,i,1));
      IF rtn>127 THEN
  &nb