mysql °¢À­²®Êý×Öת»»ÖÐÎĺ¯Êý

CREATE DEFINER=`root`@`%` FUNCTION `sp_cn`(n_LowerMoney  decimal(15,2)) RETURNS varchar(200) CHARSET utf8
begin
Declare v_LowerStr  VARCHAR(200) ;
Declare v_UpperPart VARCHAR(200) ;
Declare v_UpperStr VARCHAR(200) ;
Declare i_I int ;
set v_LowerStr = LTRIM(RTRIM(ROUND(n_LowerMoney,2 ) ) ) ;
set i_I = 1 ;
set v_UpperStr = '' ;
while ( i_I <=char_length(v_LowerStr ) )  do
set v_UpperPart = CONCAT( case substring(v_LowerStr,char_length(v_LowerStr) - i_I + 1,1 )
WHEN '.' THEN 'Ôª'
WHEN '0' THEN 'Áã'
WHEN '1' THEN 'Ò¼'
WHEN '2' THEN '·¡'
WHEN '3' THEN 'Èþ'
WHEN '4' THEN 'ËÁ'
WHEN '5' THEN 'Îé'
WHEN '6' THEN '½'
WHEN '7' THEN 'Æâ'
WHEN '8' THEN '°Æ'
WHEN '9' THEN '¾Á'
END,
case i_I
WHEN 1 THEN '·Ö'
WHEN 2 THEN '½Ç'
WHEN 3 THEN ''
WHEN 4 THEN ''
WHEN 5 THEN 'Ê°'
WHEN 6 THEN '°Û'
WHEN 7 THEN 'Ǫ'
WHEN 8 THEN 'Íò'
WHEN 9 THEN 'Ê°'
WHEN 10 THEN '°Û'
WHEN 11 THEN 'Ǫ'
WHEN 12 THEN 'ÒÚ'
WHEN 13 THEN 'Ê°'
WHEN 14 THEN '°Û'
WHEN 15 THEN 'Ǫ'
WHEN 16 THEN 'Íò'
ELSE ''
END );
set v_UpperStr =CONCAT( v_UpperPart , v_UpperStr) ;
set i_I = i_I + 1 ;
end while;
set v_UpperStr = REPLACE(v_UpperStr,'ÁãÊ°','Áã') ;
set v_UpperStr = REPLACE(v_UpperStr,'Áã°Û','Áã') ;
set v_UpperStr = REPLACE(v_UpperStr,'ÁãǪ','Áã') ;
set v_UpperStr = REPLACE(v_UpperStr,'ÁãÁãÁã','Áã') ;
set v_UpperStr = REPLACE(v_UpperStr,'ÁãÁã','Áã') ;
set v_UpperStr = REPLACE(v_UpperStr,'Áã½ÇÁã·Ö','Õû') ;
set v_UpperStr = REPLACE(v_UpperStr,'Áã·Ö','Õû') ;
set v_UpperStr = REPLACE(v_UpperStr,'Áã½Ç','Áã') ;
set v_UpperStr = REPLACE(v_UpperStr,'ÁãÒÚÁãÍòÁãÔª','ÒÚÔª') ;
set v_UpperStr = REPLACE(v_UpperStr,'ÒÚÁãÍòÁãÔª','ÒÚÔª') ;
set v_UpperStr = REPLACE(v_UpperStr,'ÁãÒÚÁãÍò','ÒÚ') ;
set v_UpperStr = REPLACE(v_UpperStr,'ÁãÍòÁãÔª','ÍòÔª') ;
set v_UpperStr = REPLACE(v_UpperStr,'ÍòÁãÔª','ÍòÔª') ;
set v_UpperStr = REPLACE(v_UpperStr,'ÁãÒÚ','ÒÚ') ;
set v_UpperStr = REPLACE(v_UpperStr,'ÁãÍò','Íò') ;
set v_UpperStr = REPLACE(v_UpperStr,'ÁãÔª','Ôª') ;
set v_Up