SQL Server

Load an Ed25519 Key from Raw Hex

Demonstrates the Chilkat PrivateKey.LoadEd25519 method, which loads an Ed25519 key pair from raw hexadecimal. The first argument is the 32-byte private seed and the second is the 32-byte public key. Each nonempty value must be exactly 64 hexadecimal digits.

Background: Ed25519 keys are compact fixed-size byte strings rather than the structured ASN.1 of RSA, so raw hex is a natural way to carry them. This loader takes the 32-byte seed (from which the full private key is derived) and the 32-byte public key directly, which is useful when a key originates from a system that emits raw values rather than a PEM or JWK container. For a standard container, use one of the PEM/PKCS #8/JWK loaders instead.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

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

    --  Demonstrates the PrivateKey.LoadEd25519 method, which loads an Ed25519 key pair from raw
    --  hexadecimal.  The 1st argument is the 32-byte private seed and the 2nd is the 32-byte public
    --  key.  Each nonempty value must be exactly 64 hexadecimal digits.

    DECLARE @privKey int
    EXEC @hr = sp_OACreate 'Chilkat.PrivateKey', @privKey OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    --  The 32-byte Ed25519 private seed and public key, each as 64 hex digits.
    DECLARE @privSeedHex nvarchar(4000)
    SELECT @privSeedHex = '9d61b19deffkbfa4ffa4d8c8f8a5b4a3d9e8c7b6a5f4e3d2c1b0a9f8e7d6c5b4'
    DECLARE @pubKeyHex nvarchar(4000)
    SELECT @pubKeyHex = 'd75a980182b10ab7d54bfed3c964073a0ee172f3daa62325af021a68f707511a'

    EXEC sp_OAMethod @privKey, 'LoadEd25519', @success OUT, @privSeedHex, @pubKeyHex
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @privKey, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @privKey
        RETURN
      END


    PRINT 'Loaded an Ed25519 private key.'

    EXEC @hr = sp_OADestroy @privKey


END
GO