Breaking News: Grepper is joining You.com. Read the official announcement!

html entity decode in sql query

Upset Unicorn answered on December 5, 2021 Popularity 5/10 Helpfulness 2/10

answer html entity decode in sql query

html entity decode in sql query

Comment

DECLARE @htmlNames TABLE 
(
    ID INT IDENTITY(1,1), 
    asciiDecimal INT, 
    htmlName varchar(50)
);

INSERT INTO @htmlNames 
VALUES 
    (34,'"'),
    (38,'&'),
    (60,'<'),
    (62,'>'),
    (160,' '),
    (161,'¡'),
    (162,'¢')
;

DECLARE @inputString varchar(max)= '&test&quot;<String>"&';
DECLARE @resultString varchar(max) = @inputString;

-- Simple HTML-decode:
SELECT
    @resultString = Replace(@resultString COLLATE Latin1_General_CS_AS, htmlName, NCHAR(asciiDecimal))
FROM
    @htmlNames
;

SELECT @resultString;
-- Output: &test"<String>"&


-- Multiple HTML-decode:
SET @resultString = @inputString;

DECLARE @temp varchar(max) = '';
WHILE @resultString != @temp
BEGIN
    SET @temp = @resultString;

    SELECT
        @resultString = Replace(@resultString COLLATE Latin1_General_CS_AS, htmlName, NCHAR(asciiDecimal))
    FROM
        @htmlNames
    ;
END;

SELECT @resultString;
-- Output: &test"<String>"&

Popularity 5/10 Helpfulness 2/10 Language html

Source: stackoverflow.com

Tags: decode entity html sql

Link to this answer
Share Copy Link

Contributed on Dec 05 2021

Upset Unicorn

0 Answers Avg Quality 2/10

html entity decode in sql query

Contents

More Related Answers

html entity decode in sql query

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.