在SQL中，将汉字作URL编码（ANSI）

--先创建自定义函数
CREATE FUNCTION dbo.StrToUrlEncode(@str VARCHAR(4000))
RETURNS VARCHAR(4000)
AS
BEGIN
    DECLARE @n INT
    DECLARE @tmp VARCHAR(10)
    DECLARE @tmpUrl VARBINARY(10)
    DECLARE @tmpStr VARCHAR(10)
    DECLARE @ReStr VARCHAR(4000)
    SET @n = 1
    SET @ReStr = ''
    WHILE @n <= LEN(@str) 
    BEGIN
        SET @tmp = SUBSTRING(@str, @n, 1)
        SET @tmpUrl = CAST(@tmp AS VARBINARY(10))
        SET @tmpStr = master.dbo.fn_varbintohexstr (@tmpUrl)  
        IF LEN(@tmpStr)=4 SET @tmpStr = '%' + SUBSTRING(@tmpStr,3,2)
        IF LEN(@tmpStr)=6 SET @tmpStr = '%' + SUBSTRING(@tmpStr,3,2) + '%' + SUBSTRING(@tmpStr,5,2)
        SET @ReStr = @ReStr + @tmpStr
        SET @n = @n + 1
    END
    RETURN UPPER(@ReStr)
END

--调用函数
SELECT dbo.StrToUrlEncode('测试')

转载于:https://www.cnblogs.com/yw1530/archive/2011/02/11/1951464.html