Base64_To_Unicode

Converts Base64 data to a Unicode nvarchar String

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

Syntax:

SELECT SQLHTTP.net.Base64_To_Unicode ( @Base64 )

Arguments:

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



Return Type:

nvarchar(MAX)



Sample Usage:


DECLARE @Text nvarchar(MAX)
SET @Text = 'VABoAGUAIABxAHUAaQBjAGsAIABiAHIAbwB3AG4AIABmAG8AeAAgAGoAdQBtAHAAcwAgAG8AdgBlAHIAIAB0AGgAZQAgAGwAYQB6AHkAIABkAG8AZwA='

SELECT SQLHTTP.net.Base64_To_Unicode(@Text)

DECLARE @Text nvarchar(MAX)

SET @Text = 'VABoAGUAIABxAHUAaQBjAGsAIABiAHIAbwB3AG4AIABmAG8AeAAgAGoAdQBtAHAAcwAgAG8AdgBlAHIAIAB0AGgAZQAgAGwAYQB6AHkAIABkAG8AZwA='

SELECT SQLHTTP.net.Base64_To_Unicode(@Text)

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

The quick brown fox jumps over the lazy dog



Base64_To_Unicode

Featured API Wrapper Code / SQL Server