In Microsoft SQL I have a column of type 'image' and I am unable to view this column with the n8n node

Questions
1

In Microsoft SQL I have a column of type ‘image’ when I use the query:

SELECT TOP 1
rowguid,
IMAGE
FROM PHOTOS

I receive data from the IMAGE column in Buffer format, but I need to receive or transform it to base64, how can I do this?

image
image1133×905 50.9 KB

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hey @rhafaelcm,

Welcome to the community :heart_hands:

It sounds like we might need to add an option to the node to return binary data as base64. For now though the best I can think of would be to try using a code node after the SQL node to do the conversion, I don’t have an example to hand but I think there are examples here on the forum for working with binary data in a code node if it helps.

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.