html sql编码转换为字符串,sql-server – 如何将字符串转换为以UTF-8编码的字符串,反之亦然？...

这个功能似乎可以完成这项工作.

CREATE FUNCTION [dbo].[UrlDecodeUTF8](@URL varchar(3072))

RETURNS varchar(3072)

AS

BEGIN

DECLARE @Position INT,

@Base CHAR(16),

@Code INT,

@Pattern CHAR(21)

SELECT @URL = REPLACE(@URL, '%c3', '')

SELECT @Base = '0123456789abcdef',

@Pattern = '%[%][0-9a-f][0-9a-f]%',

@Position = PATINDEX(@Pattern, @URL)

WHILE @Position > 0

SELECT @Code = Cast(CONVERT(varbinary(4), '0x' + SUBSTRING(@URL, @Position + 1, 2), 1) As int),

@URL = STUFF(@URL, @Position, 3, NCHAR(@Code + 64)),

@Position = PATINDEX(@Pattern, @URL)

RETURN REPLACE(@URL, '+', ' ')

END