(SQL Server) Blowfish CFB Mode Encryption

Demonstrates how to encrypt using Blowfish CFB (Cipher Feedback) mode.

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

    -- Use "blowfish2" to produce correct results that match published blowfish test vectors.
    EXEC sp_OASetProperty @crypt, 'CryptAlgorithm', 'blowfish2'
    EXEC sp_OASetProperty @crypt, 'CipherMode', 'cfb'
    EXEC sp_OASetProperty @crypt, 'KeyLength', 256

    -- EncodingMode specifies the encoding of the output for
    -- encryption, and the input for decryption.
    -- It may be "hex", "url", "base64", "quoted-printable", or many other choices.
    EXEC sp_OASetProperty @crypt, 'EncodingMode', 'hex'

    -- The block size of the blowfish algoirthm is 8 bytes, therefore the IV is 8 bytes.
    DECLARE @ivHex nvarchar(4000)
    SELECT @ivHex = '0001020304050607'
    EXEC sp_OAMethod @crypt, 'SetEncodedIV', NULL, @ivHex, 'hex'

    -- The secret key must equal the size of the key.  For
    -- 256-bit encryption, the binary secret key is 32 bytes.
    DECLARE @keyHex nvarchar(4000)
    SELECT @keyHex = '603deb1015ca71be2b73aef0857d77811f352c073b6108d72d9810a30914dff4'
    EXEC sp_OAMethod @crypt, 'SetEncodedKey', NULL, @keyHex, 'hex'

    -- Encrypt a string...
    DECLARE @encStr nvarchar(4000)
    EXEC sp_OAMethod @crypt, 'EncryptStringENC', @encStr OUT, 'In all intellectual debates, both sides tend to be correct in what they affirm, and wrong in what they deny. -- John Stuart Mill'

    PRINT @encStr

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

    EXEC sp_OASetProperty @decrypt, 'CryptAlgorithm', 'blowfish2'
    EXEC sp_OASetProperty @decrypt, 'CipherMode', 'cfb'
    EXEC sp_OASetProperty @decrypt, 'KeyLength', 256
    EXEC sp_OASetProperty @decrypt, 'EncodingMode', 'hex'
    EXEC sp_OAMethod @decrypt, 'SetEncodedIV', NULL, @ivHex, 'hex'
    EXEC sp_OAMethod @decrypt, 'SetEncodedKey', NULL, @keyHex, 'hex'

    -- Now decrypt:
    DECLARE @decStr nvarchar(4000)
    EXEC sp_OAMethod @decrypt, 'DecryptStringENC', @decStr OUT, @encStr

    PRINT @decStr

    EXEC @hr = sp_OADestroy @crypt
    EXEC @hr = sp_OADestroy @decrypt


END
GO