SQL Server

Get an Ed25519 Key in Raw Hex Format

See more Ed25519 Examples

Demonstrates how to get the private and public key parts of an Ed25519 key in lowercase hex formmat.

Note: This example requires Chilkat v9.5.0.83 or greater.

SQL Server

-- 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)
    DECLARE @success int
    SELECT @success = 0

    -- This example assumes the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    -- Load an Ed25519 key from some format..
    DECLARE @privKey int
    EXEC @hr = sp_OACreate 'Chilkat.PrivateKey', @privKey OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- This loads an Ed25519 key from an unencrypted PEM file (no password required).
    EXEC sp_OAMethod @privKey, 'LoadAnyFormatFile', @success OUT, 'qa_data/eddsa/ed25519.pem', ''
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @privKey, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @privKey
        RETURN
      END

    -- The key type should be "ed25519" to indicate an Ed25519 key.

    EXEC sp_OAGetProperty @privKey, 'KeyType', @sTmp0 OUT
    PRINT 'key type = ' + @sTmp0

    -- What is the size of the private key in bits?  (should always be 256 bits for Ed25519)

    EXEC sp_OAGetProperty @privKey, 'BitLength', @iTmp0 OUT
    PRINT 'size in bits = ' + @iTmp0

    -- Get the private and public key parts in raw hex format:
    DECLARE @sbPubKeyHex int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbPubKeyHex OUT

    DECLARE @privKeyHex nvarchar(4000)
    EXEC sp_OAMethod @privKey, 'GetRawHex', @privKeyHex OUT, @sbPubKeyHex

    -- We should have a 32-byte private key (a 64 character hex string).

    PRINT 'private key = ' + @privKeyHex

    -- We should have a 32-byte public key (a 64 character hex string).

    EXEC sp_OAMethod @sbPubKeyHex, 'GetAsString', @sTmp0 OUT
    PRINT 'public key = ' + @sTmp0

    -- Sample output:
    -- key type = ed25519
    -- size in bits = 256
    -- private key = d4ee72dbf913584ad5b6d8f1f769f8ad3afe7c28cbf1d4fbe097a88f44755842
    -- public key = 19bf44096984cdfe8541bac167dc3b96c85086aa30b6b6cb0c5c38ad703166e1

    EXEC @hr = sp_OADestroy @privKey
    EXEC @hr = sp_OADestroy @sbPubKeyHex


END
GO