I am trying to convert the attachment tables DATA tab (BLOB/VARBINARY) into Base64.
SELECT CAST(CAST('' as XML).value('xs:base64Binary(sql:column("DATA"))', 'VARBINARY(MAX)') AS NVARCHAR(MAX))
WHERE REL_OBJECTID = '51'
Is there a way to convert the BLOB into Base64?
Kind of.... I was able to get it to work but only with images the size of thumbnails. Anything "large" would get cut off about 1 inches from the top.
From what I read on the WWW it should work with normal sized images. The string for a base64 is very large (but is under the varchar(max) limit)