(SQL Server) URL Decode
Demonstrates how to URL decode a string.
// Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
//
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @sTmp0 nvarchar(4000)
DECLARE @sb int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sb OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
-- Here we wish to URL decode the following string:
DECLARE @success int
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
|