Conversao de base 64 para binario e vice versa obs: varbinary(MAX) (sqlserver) blob (sqllite)
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
-- Convert Base64 value in a variable to varbinary: declare @str varchar(20); set @str = '3qAAAA=='; select cast(N'' as xml).value('xs:base64Binary(sql:variable("@str"))', 'varbinary(20)'); -- Convert binary value in a variable to Base64: declare @bin varbinary(20); set @bin = 0xDEA00000; select cast(N'' as xml).value('xs:base64Binary(xs:hexBinary(sql:variable("@bin")))', 'varchar(20)'); -- Convert varbinary value in a column to Base64: select top (10) cast(N'' as xml).value('xs:base64Binary(xs:hexBinary(sql:column("qs.sql_handle")))', 'varchar(512)') as sql_handle_base64 into #t from sys.dm_exec_query_stats as qs; -- Convert Base64 value in a column to varbinary: select cast(N'' as xml).value('xs:base64Binary(sql:column("t.sql_handle_base64"))', 'varbinary(20)') as sql_handle from #t as t; drop table #t; |