search

tediousjs / node-mssql

Microsoft SQL Server client for Node.js
https://tediousjs.github.io/node-mssql
MIT License
2.23k stars 467 forks source link

Can't write null to varbinary column #1469

Closed code4break closed 5 months ago

code4break commented 1 year ago

Hi,

I can't write null to a varbinary column, that is allowed to contain null values.

Expected behaviour:

Insert null to a varbinary column works without throwing an error.

Actual behaviour:

Error: Implicit conversion from data type nvarchar to varbinary is not allowed. Use the CONVERT function to run this query.

Software versions

dhensby commented 1 year ago

Can you provide some replication code, please?

code4break commented 1 year ago

Can you provide some replication code, please?

I will create a public repo for that.