Question

how do i convert a picture from filesystem into Base64 using SQL

  • 8 February 2024
  • 1 reply
  • 30 views

Userlevel 2
Badge +6

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?


1 reply

Userlevel 7
Badge +5

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.

Reply