Base64_To_Binary

Converts Base64 data to Binary

Free Function
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

SELECT SQLHTTP.net.Base64_To_Binary ( @Base64 )

Arguments:

Name	Type	Description
@Base64	varchar(MAX)	Base64 data string



Return Type:

varbinary(MAX)



Sample Usage:


DECLARE @Text nvarchar(MAX)
DECLARE @Base64 nvarchar(MAX)
DECLARE @Bin varbinary(MAX)

SET @Text = 'The quick brown fox jumps over the lazy dog'

SET @Base64 = SQLHTTP.net.Unicode_To_Base64(@Text)

SET @Bin = SQLHTTP.net.Base64_To_Binary(@Base64)

SELECT @Bin

DECLARE @Text nvarchar(MAX)

DECLARE @Base64 nvarchar(MAX)

DECLARE @Bin varbinary(MAX)

SET @Text = 'The quick brown fox jumps over the lazy dog'

SET @Base64 = SQLHTTP.net.Unicode_To_Base64(@Text)

SET @Bin = SQLHTTP.net.Base64_To_Binary(@Base64)

SELECT @Bin

--------------------------------------------------

0x540068006500200071007500690063006B002000620072006F0077006E00200066006F00780020006A0075006D007000730020006F00760065007200200074006800650020006C0061007A007900200064006F006700



Base64_To_Binary

Featured API Wrapper Code / SQL Server