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?
Answer
how do i convert a picture from filesystem into Base64 using SQL
- Sidekick
Best answer by Anne Buit
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.
This topic has been closed for replies.
+5Hi 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.
- Sidekick
Hi Anne,
Thanks a lot. This is now working just fine. You saved me a lot of searching time. 👍
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.