topic Re: Convert VARBINARY (BLOB) to Base64 String using T-SQL in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/convert-varbinary-blob-to-base64-string-using-t/m-p/765513#M632 <HTML><HEAD></HEAD><BODY><P>Did you figure this out?</P></BODY></HTML> Fri, 05 Jan 2018 20:04:26 GMT DavidBuehler 2018-01-05T20:04:26Z Convert VARBINARY (BLOB) to Base64 String using T-SQL https://community.esri.com/t5/geodatabase-questions/convert-varbinary-blob-to-base64-string-using-t/m-p/765512#M631 <HTML><HEAD></HEAD><BODY><P>I am trying to convert the attachment tables DATA tab (BLOB/VARBINARY) into Base64. &nbsp;</P><P></P><P>USE UTILITIES<BR />SELECT CAST(CAST('' as XML).value('xs:base64Binary(sql:column("DATA"))', 'VARBINARY(MAX)') AS NVARCHAR(MAX))</P><P>FROM FeatureClass_ATTACH_evw<BR />WHERE REL_OBJECTID = '51'<BR />go</P><P></P><P><SPAN>Results:</SPAN></P><P></P><P><SPAN>"�က䙊䙉Ā ĀĀ"</SPAN></P><P></P><P></P><P>Is there a way to convert the BLOB into Base64?</P></BODY></HTML> Wed, 12 Jul 2017 13:35:20 GMT https://community.esri.com/t5/geodatabase-questions/convert-varbinary-blob-to-base64-string-using-t/m-p/765512#M631 TL2 2017-07-12T13:35:20Z Re: Convert VARBINARY (BLOB) to Base64 String using T-SQL https://community.esri.com/t5/geodatabase-questions/convert-varbinary-blob-to-base64-string-using-t/m-p/765513#M632 <HTML><HEAD></HEAD><BODY><P>Did you figure this out?</P></BODY></HTML> Fri, 05 Jan 2018 20:04:26 GMT https://community.esri.com/t5/geodatabase-questions/convert-varbinary-blob-to-base64-string-using-t/m-p/765513#M632 DavidBuehler 2018-01-05T20:04:26Z Re: Convert VARBINARY (BLOB) to Base64 String using T-SQL https://community.esri.com/t5/geodatabase-questions/convert-varbinary-blob-to-base64-string-using-t/m-p/765514#M633 <HTML><HEAD></HEAD><BODY><P>Kind of.... I was able to get it to work but only with images the size of thumbnails.&nbsp; Anything "large" would get cut off about 1 inches from the top.&nbsp;&nbsp;</P><P></P><P>From what I read on the WWW it <EM>should</EM> work with normal sized images.&nbsp; The string for a base64 is very large (but is under the varchar(max) limit)</P></BODY></HTML> Fri, 05 Jan 2018 21:47:35 GMT https://community.esri.com/t5/geodatabase-questions/convert-varbinary-blob-to-base64-string-using-t/m-p/765514#M633 TL2 2018-01-05T21:47:35Z