SQL Server

URL Decode

Demonstrates how to URL decode a string. SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    DECLARE @sb int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sb OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    --  Here we wish to URL decode the following string:
    EXEC sp_OAMethod @sb, 'Append', @success OUT, '%D7%9E%D7%95%D7%A6%D7%A81.jpg'

    --  Notice the above string contains Hebrew chars using the utf-8 byte representation.
    --  See https://www.loc.gov/marc/specifications/codetables/BasicHebrew.html
    --  For example:  D79E is the HEBREW LETTER MEM

    --  Therefore, when we decode to binary bytes, we must interpret the bytes as utf-8
    --  to get characters.

    --  Tell Chilkat to URL decode like this:
    EXEC sp_OAMethod @sb, 'Decode', @success OUT, 'url', 'utf-8'

    --  sb now contains the decoded string.
    EXEC sp_OAMethod @sb, 'GetAsString', @sTmp0 OUT
    PRINT @sTmp0

    EXEC @hr = sp_OADestroy @sb


END
GO