Skip to main content

I am creating an api link and need to upload an image as BASE64 code to add it in the GraphQl string. However, I only have the reference to the disk of the image in the database. How can I convert such an image to BASE64 code using TSQL?

Hi Marco,

You can use a trick with XML to turn binary data into base64 in T-SQL:

declare @binary_data varbinary(max) = 0x0102030405060708090A0B0C0D0E0F

-- Turn into base64
select cast('' as xml).value('xs:base64Binary(sql:variable("@binary_data"))', 'varchar(max)')

To obtain the binary data from the file, I’d suggest using a Read file connector.

Hi Anne,

 

Thanks a lot. This is now working just fine. You saved me a lot of searching time. 👍

Terms & ConditionsCookie settings