(SQL Server) Base64 Encode/Decode a String
SQL Server example to base-64 encode and decode a string.
// Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
//
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @bd int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.BinData', @bd OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @s nvarchar(4000)
SELECT @s = 'A friend called me up the other day and talked about investing in a dot-com that sells lobsters. Internet lobsters. Where will this end? --Donald Trump'
DECLARE @success int
EXEC sp_OAMethod @bd, 'AppendString', @success OUT, @s, 'utf-8'
DECLARE @strBase64 nvarchar(4000)
EXEC sp_OAMethod @bd, 'GetEncoded', @strBase64 OUT, 'base64'
PRINT @strBase64
-- To decode:
DECLARE @bd2 int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.BinData', @bd2 OUT
EXEC sp_OAMethod @bd2, 'AppendEncoded', @success OUT, @strBase64, 'base64'
DECLARE @decoded nvarchar(4000)
EXEC sp_OAMethod @bd2, 'GetString', @decoded OUT, 'utf-8'
PRINT @decoded
EXEC @hr = sp_OADestroy @bd
EXEC @hr = sp_OADestroy @bd2
END
GO
|