I created an insert query with parameters that includes inserting images from bubble into image fields in MS SQL Server. When I try to initialize the query in Bubble, I get the following error: SQL Database Connector Query issue Operand type clash: nvarchar is incompatible with image
The especially odd part is that there are no nvarchar data types in the SQL table into which I am trying to insert data.
I have double checked that all image datatype parameters in Bubble match the destination field types in SQL… I suspect the issue is that I do not have test values for the image items. Any hints?
Quick note here: bubble images / files are stored in our database as urls linking to an uploaded file. That’s where the nvarchar comes from – we send text to MS SQL as nvarchar. In contrast, the MS SQL “image” type (which is deprecated in the latest version, as a heads up – they want you to switch to using varbinary) expects you to be storing the binary data of an image. So that’s why this isn’t working. If you want to get the link from Bubble into MS SQL, create a nvarchar (or another flavor of text) column on the MS SQL side of the things. If you need to get the binary data into MS SQL, you’ll need something that can download the data from the link, and write it to your database – Bubble doesn’t have out of the box support for this right now.
