(SQL Server) RIPEMD Hash a String

Demonstrates how to RIPEMD hash a string using RIPEMD-128, RIPEMD-160, RIPEMD-256, and RIPEMD-320.

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
    -- This example assumes the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    DECLARE @crypt int
    -- Use "Chilkat_9_5_0.Crypt2" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Crypt2', @crypt OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @content nvarchar(4000)
    SELECT @content = 'abcdefghijklmnopqrstuvwxyz'

    -- The desired output is a hexidecimal string:
    EXEC sp_OASetProperty @crypt, 'EncodingMode', 'hex'

    -- Set the hash algorithm:
    EXEC sp_OASetProperty @crypt, 'HashAlgorithm', 'ripemd128'

    DECLARE @hashStr nvarchar(4000)

    EXEC sp_OAMethod @crypt, 'HashStringENC', @hashStr OUT, @content


    PRINT @hashStr

    -- The output is:
    -- FD2AA607F71DC8F510714922B371834E

    EXEC sp_OASetProperty @crypt, 'HashAlgorithm', 'ripemd160'
    EXEC sp_OAMethod @crypt, 'HashStringENC', @hashStr OUT, @content

    PRINT @hashStr

    -- The output is:
    -- F71C27109C692C1B56BBDCEB5B9D2865B3708DBC

    EXEC sp_OASetProperty @crypt, 'HashAlgorithm', 'ripemd256'
    EXEC sp_OAMethod @crypt, 'HashStringENC', @hashStr OUT, @content

    PRINT @hashStr

    -- The output is:
    -- 649D3034751EA216776BF9A18ACC81BC7896118A5197968782DD1FD97D8D5133

    EXEC sp_OASetProperty @crypt, 'HashAlgorithm', 'ripemd320'
    EXEC sp_OAMethod @crypt, 'HashStringENC', @hashStr OUT, @content

    PRINT @hashStr

    -- The output is:
    -- CABDB1810B92470A2093AA6BCE05952C28348CF43FF60841975166BB40ED234004B8824463E6B00

    EXEC @hr = sp_OADestroy @crypt


END
GO