(SQL Server) Base64url Encoding

Base64url encoding is identical to base64 encoding except it uses non-reserved URL characters (e.g. '–' is used instead of '+', and '_' is used instead of '/') and it omits the padding characters. Chilkat adds support for "base64url" in version 9.5.0.56. (To be released Q1 2016.) The list of binary encodings supported by Chilkat are documented at Chilkat Binary Encodings For any supported encoding, such as base64, hex, url, quoted-printable, modbase64, base64url, etc., the encoding name may be used in any "EncodingMode" property or in any method argument that specifies a binary encoding. (Please note that a "binary encoding" is different than a "character encoding". Character encodings supported by Chilkat are listed at Chilkat Character Encodings.) This example demonstrates using base64url encoding by setting the RSA object's EncodingMode property equal to "base64url".

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
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    -- This example requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    -- Create an instance of a certificate store object, load a PFX file,
    -- locate the certificate we need, and use it for signing.
    -- (a PFX file may contain more than one certificate.)
    DECLARE @certStore int
    -- Use "Chilkat_9_5_0.CertStore" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.CertStore', @certStore OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- The 1st argument is the filename, the 2nd arg is the 
    -- PFX file's password:
    DECLARE @success int
    EXEC sp_OAMethod @certStore, 'LoadPfxFile', @success OUT, 'chilkat.pfx', 'test'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @certStore, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @certStore
        RETURN
      END

    DECLARE @cert int
    EXEC sp_OAMethod @certStore, 'FindCertBySubject', @cert OUT, 'Chilkat Software, Inc.'
    EXEC sp_OAGetProperty @certStore, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        EXEC sp_OAGetProperty @certStore, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @certStore
        RETURN
      END

    DECLARE @pkey int

    EXEC sp_OAMethod @cert, 'ExportPrivateKey', @pkey OUT
    EXEC sp_OAGetProperty @cert, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        EXEC sp_OAGetProperty @cert, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @cert

        EXEC @hr = sp_OADestroy @certStore
        RETURN
      END
    EXEC @hr = sp_OADestroy @cert

    -- Get the private key in XML format:
    DECLARE @pkeyXml nvarchar(4000)
    EXEC sp_OAMethod @pkey, 'GetXml', @pkeyXml OUT

    DECLARE @rsa int
    -- Use "Chilkat_9_5_0.Rsa" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Rsa', @rsa OUT

    -- Import the private key into the RSA component:
    EXEC sp_OAMethod @rsa, 'ImportPrivateKey', @success OUT, @pkeyXml
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @rsa, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @pkey

        EXEC @hr = sp_OADestroy @certStore
        EXEC @hr = sp_OADestroy @rsa
        RETURN
      END

    -- This example will sign a string, and receive the signature
    -- as a base64url encoded string.  Therefore, set the encoding mode
    -- to "base64url":
    EXEC sp_OASetProperty @rsa, 'EncodingMode', 'base64url'
    EXEC sp_OASetProperty @rsa, 'LittleEndian', 0

    DECLARE @strData nvarchar(4000)
    SELECT @strData = 'This is the string to be signed.'
    DECLARE @strSig nvarchar(4000)
    EXEC sp_OAMethod @rsa, 'SignStringENC', @strSig OUT, @strData, 'sha256'

    EXEC @hr = sp_OADestroy @pkey


    PRINT @strSig

    EXEC @hr = sp_OADestroy @certStore
    EXEC @hr = sp_OADestroy @rsa


END
GO