urldecode
来源:互联网 发布:手机软件制作软件 编辑:程序博客网 时间:2024/06/04 17:58
DROP FUNCTION IF EXISTS urldecode;
DELIMITER |
CREATE FUNCTION urldecode (s VARCHAR(4096)) RETURNS VARCHAR(4096)
DETERMINISTIC
CONTAINS SQL
BEGIN
DECLARE c VARCHAR(4096) DEFAULT '';
DECLARE pointer INT DEFAULT 1;
DECLARE h CHAR(2);
DECLARE h1 CHAR(1);
DECLARE h2 CHAR(1);
DECLARE s2 VARCHAR(4096) DEFAULT '';
IF ISNULL(s) THEN
RETURN NULL;
ELSE
SET s2 = '';
WHILE pointer <= LENGTH(s) DO
SET c = MID(s,pointer,1);
IF c = '+' THEN
SET c = ' ';
ELSEIF c = '%' AND pointer + 2 <= LENGTH(s) THEN
SET h1 = LOWER(MID(s,pointer+1,1));
SET h2 = LOWER(MID(s,pointer+2,1));
IF (h1 BETWEEN '0' AND '9' OR h1 BETWEEN 'a' AND 'f')
AND
(h2 BETWEEN '0' AND '9' OR h2 BETWEEN 'a' AND 'f')
THEN
SET h = CONCAT(h1,h2);
SET pointer = pointer + 2;
SET c = CHAR(CONV(h,16,10));
END IF;
END IF;
SET s2 = CONCAT(s2,c);
SET pointer = pointer + 1;
END while;
END IF;
RETURN s2;
END;
|
DELIMITER ;
阅读全文
0 0
- UrlDecode
- urldecode
- urldecode
- UrlEncode UrlDecode
- urlencode urldecode
- urlencode,urldecode
- urldecode.php
- HttpUtility.UrlDecode Server.UrlDecode 区别
- URLEncode和URLDecode
- urlencode AND urldecode
- python urldecode 函数
- urlencode AND urldecode
- URLencode AND URLdecode
- ASP中URLdecode
- URLencode AND URLdecode
- javaScript UrlEncode and UrlDecode
- VC URLEncode UrlDecode
- flash urldecode函数
- 适配 iPhone X Push 过程中 TabBar 位置上移
- 0基础lua学习(三)关系运算符
- 爬虫感悟2
- python--归并排序
- java 学习字符编码
- urldecode
- java读取UTF-8文本文件第一个字符多出一个问号解决方法
- 优化jvm
- python错误调试--assert
- Java异常
- 四则运算
- 水平居中
- C++ Virtual详解
- 阿里云申请免费DV SSL证书部署https全过程