Unicode_To_Base64

Converts Unicode nvarchar string to Base64 string

Syntax:

SELECT SQLHTTP.net.Unicode_To_Base64 ( @Unicode )

Arguments:

Name	Type	Description
@Unicode	nvarchar(MAX)	Unicode data string

Return Type:

varchar(MAX)

Sample Usage:


DECLARE @Text nvarchar(MAX)
SET @Text = 'The quick brown fox jumps over the lazy dog'

SELECT SQLHTTP.net.Unicode_To_Base64(@Text)

DECLARE @Text nvarchar(MAX)

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

SELECT SQLHTTP.net.Unicode_To_Base64(@Text)

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

VABoAGUAIABxAHUAaQBjAGsAIABiAHIAbwB3AG4AIABmAG8AeAAgAGoAdQBtAHAAcwAgAG8AdgBlAHIAIAB0AGgAZQAgAGwAYQB6AHkAIABkAG8AZwA=