SQL Server

Load a Raw Ed25519 Public Key

Demonstrates the Chilkat PublicKey.LoadEd25519 method, which loads a raw Ed25519 public key from a hexadecimal string. The only argument must be exactly 64 hexadecimal characters (32 bytes).

Background: An Ed25519 public key is simply a fixed 32-byte value, so raw hex is a natural way to carry it — no ASN.1 container required. This loader takes those bytes directly, which is useful when a key comes from a system that emits raw values rather than a PEM or JWK. For a standard container, use LoadFromString or one of the DER/PEM 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 PublicKey.LoadEd25519 method, which loads a raw Ed25519 public key from a
    --  hexadecimal string.  The only argument must be exactly 64 hexadecimal characters (32 bytes).

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

    --  The 32-byte Ed25519 public key as 64 hex digits.
    DECLARE @pubKeyHex nvarchar(4000)
    SELECT @pubKeyHex = 'd75a980182b10ab7d54bfed3c964073a0ee172f3daa62325af021a68f707511a'

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


    PRINT 'Loaded an Ed25519 public key.'

    EXEC @hr = sp_OADestroy @pubKey


END
GO