Taliba Martins

DELIMITER $$

DROP FUNCTION IF EXISTS `_functions`.`url_decode`$$
CREATE DEFINER=`root`@`%` FUNCTION `_functions`.`url_decode`(original_text text) RETURNS text CHARSET latin1
BEGIN
declare new_text text default null;
declare pointer int default 1;

set new_text = replace(original_text,’+',’ ‘);
while (LOCATE(”%”,new_text,pointer) <> 0 )&& (pointer < length(new_text)) do
set pointer = LOCATE(”%”,new_text,pointer);
set new_text = concat(left(new_text,pointer-1), char(conv(mid(new_text,pointer+1,2),16,10)), right(new_text,length(new_text)-(pointer+2)));
set pointer = pointer + 1;
end while;

return new_text;

END;

$$

DELIMITER ;

Repare que ele utiliza um outro banco para guardar as funções.

Por Garret Hill

This entry was posted on Thursday, April 24th, 2008 at 9:15 am and is filed under Dicas. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.