推荐订阅源

CREATE TABLE `tbl_py` (
`PY` char(1) character set utf8 NOT NULL, 
`HZ` char(1) NOT NULL default '',         
PRIMARY KEY  (`PY`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
insert into tbl_py values
('A','骜'),
('B','簿'),
('C','错'),
('D','鵽'),
('E','樲'),
('F','鳆'),
('G','腂'),
('H','夻'),
('J','攈'),
('K','穒'),
('L','鱳'),
('M','旀'),
('N','桛'),
('O','沤'),
('P','曝'),
('Q','囕'),
('R','鶸'),
('S','蜶'),
('T','箨'),
('W','鹜'),
('X','鑂'),
('Y','韵'),
('Z','咗');
DELIMITER $$

DROP FUNCTION IF EXISTS `f_hzcode`$$

CREATE FUNCTION `f_hzcode`(
 words   varchar(255)) RETURNS  char(1) CHARSET utf8
BEGIN  
  declare fpy char(1);  
  declare pc char(1);  
  declare cc char(4);  
  set @fpy = UPPER(left(words,1));  
  set @pc = (CONVERT(@fpy   USING   gbk));  
  set @cc = hex(@pc);  
  if @cc >= "8140" and @cc <="FEA0" then 
    begin  
      select PY from tbl_py where hz>=@pc limit 1 into @fpy;
    end;  
  end   if;  
  Return   @fpy;  
  END$$

DELIMITER ;