SQL Server

Get a Private Key's Raw Hex Value

Demonstrates the Chilkat PrivateKey.GetRawHex method, which returns the raw private value as lowercase hexadecimal and replaces the contents of the supplied StringBuilder with the corresponding raw public key.

Note: The file paths are relative to the application's current working directory. Absolute paths may also be used. Supply the paths appropriate to your own environment.

Background: This drops below the structured container formats to the bare key bytes as hex, which is meaningful chiefly for fixed-size keys such as EC and Ed25519 where a key is essentially a fixed byte string. It is the export to use when another system wants raw values rather than PEM or JWK — the counterpart to LoadEd25519. Both the returned private hex and the public value are produced in one call.

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

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

    EXEC sp_OAMethod @privKey, 'LoadPemFile', @success OUT, 'qa_data/private.pem'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @privKey, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @privKey
        RETURN
      END

    --  GetRawHex returns the raw private value as lowercase hex, and replaces the contents of the
    --  StringBuilder argument with the corresponding raw public key.  This is most meaningful for
    --  fixed-size keys such as EC and Ed25519.
    DECLARE @sbPublic int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbPublic OUT

    DECLARE @privHex nvarchar(4000)
    EXEC sp_OAMethod @privKey, 'GetRawHex', @privHex OUT, @sbPublic
    EXEC sp_OAGetProperty @privKey, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        EXEC sp_OAGetProperty @privKey, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @privKey
        EXEC @hr = sp_OADestroy @sbPublic
        RETURN
      END


    PRINT 'Raw private value: ' + @privHex

    EXEC sp_OAMethod @sbPublic, 'GetAsString', @sTmp0 OUT
    PRINT 'Raw public key: ' + @sTmp0

    EXEC @hr = sp_OADestroy @privKey
    EXEC @hr = sp_OADestroy @sbPublic


END
GO