(SQL Server) URL Encoding Charset in POST Query Params

Demonstrates how to control the URL encoding charset in POST query params.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

// Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
//
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @sTmp0 nvarchar(4000)
    -- This example requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    -- We have the string "MÆRSK".
    DECLARE @nameWin1252Encoded nvarchar(4000)
    SELECT @nameWin1252Encoded = 'M%E6RSK'

    -- Note: The DecodeAndAppend method is newly added in Chilkat v9.5.0.87
    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

    DECLARE @success int
    EXEC sp_OAMethod @sb, 'DecodeAndAppend', @success OUT, @nameWin1252Encoded, 'url', 'windows-1252'

    DECLARE @http int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Http', @http OUT

    -- We're setting the session log filename so we can see the exact request sent.
    EXEC sp_OASetProperty @http, 'SessionLogFilename', 'qa_output/sessionLog.txt'

    -- First demonstrate a simple application/x-www-form-urlencoded POST

    DECLARE @req int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.HttpRequest', @req OUT

    -- Set the Charset = "utf-8" to cause URL encoding to use utf-8.
    EXEC sp_OASetProperty @req, 'Charset', 'utf-8'

    EXEC sp_OAMethod @sb, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @req, 'AddParam', NULL, 'name', @sTmp0

    DECLARE @resp int
    EXEC sp_OAMethod @http, 'PostUrlEncoded', @resp OUT, 'https://www.chilkatsoft.com/something', @req
    EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @sb
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @req
        RETURN
      END

    -- This is the request that is sent:
    -- Notice that utf-8 is used in the query param (the letter 'Æ' is %C3%A6)

    -- 	POST /something HTTP/1.1
    -- 	Host: www.chilkatsoft.com
    -- 	Content-Type: application/x-www-form-urlencoded
    -- 	Content-Length: 15
    -- 
    -- 	name=M%C3%A6RSK

    EXEC @hr = sp_OADestroy @resp

    -- ---------------------------------------------------------------
    -- Switch to windows-1252

    EXEC sp_OASetProperty @req, 'Charset', 'windows-1252'

    EXEC sp_OAMethod @http, 'PostUrlEncoded', @resp OUT, 'https://www.chilkatsoft.com/something', @req
    EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @sb
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @req
        RETURN
      END

    -- This is the request that is sent:
    -- Notice that windows-1252 is used in the query param (the letter 'Æ' is %E6)

    -- 	POST /something HTTP/1.1
    -- 	Host: www.chilkatsoft.com
    -- 	Content-Type: application/x-www-form-urlencoded
    -- 	Content-Length: 12
    -- 
    -- 	name=M%E6RSK

    EXEC @hr = sp_OADestroy @resp

    -- ---------------------------------------------------------------
    -- Let's do the same with SynchronousRequest, switching back to utf-8

    EXEC sp_OASetProperty @req, 'Path', '/something'
    EXEC sp_OASetProperty @req, 'HttpVerb', 'POST'
    EXEC sp_OASetProperty @req, 'ContentType', 'application/x-www-form-urlencoded'

    EXEC sp_OASetProperty @req, 'Charset', 'utf-8'

    EXEC sp_OAMethod @http, 'SynchronousRequest', @resp OUT, 'www.chilkatsoft.com', 443, 1, @req
    EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @sb
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @req
        RETURN
      END

    -- This is the request that is sent:
    -- Notice that utf-8 is used in the query param (the letter 'Æ' is %C3%A6)

    -- 	POST /something HTTP/1.1
    -- 	Host: www.chilkatsoft.com
    -- 	Content-Type: application/x-www-form-urlencoded
    -- 	Content-Length: 15
    -- 
    -- 	name=M%C3%A6RSK

    EXEC @hr = sp_OADestroy @resp

    -- ---------------------------------------------------------------
    -- Let's do a PostXml where the query params are in the HTTP request start line, 
    -- and the Content-Type is text/xml where the body of the request is XML.

    EXEC sp_OASetProperty @req, 'Path', '/something'
    EXEC sp_OASetProperty @req, 'HttpVerb', 'POST'
    EXEC sp_OASetProperty @req, 'ContentType', 'text/xml'
    EXEC sp_OAMethod @req, 'LoadBodyFromString', @success OUT, '<test>123</test>', 'utf-8'
    EXEC sp_OASetProperty @req, 'Charset', 'utf-8'

    -- Remember... our request object still contains the query param added in the above call to AddParam.

    EXEC sp_OAMethod @http, 'SynchronousRequest', @resp OUT, 'www.chilkatsoft.com', 443, 1, @req
    EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @sb
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @req
        RETURN
      END

    -- This is the request that is sent:
    -- Notice that utf-8 is used in the query param (the letter 'Æ' is %C3%A6)

    -- 	POST /something?name=M%C3%A6RSK HTTP/1.1
    -- 	Host: www.chilkatsoft.com
    -- 	Content-Type: text/xml
    -- 	Content-Length: 16
    -- 
    -- 	<test>123</test>

    EXEC @hr = sp_OADestroy @resp


    EXEC @hr = sp_OADestroy @sb
    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @req


END
GO