node-mssql icon indicating copy to clipboard operation
node-mssql copied to clipboard

Can't write null to varbinary column

Open code4break opened this issue 2 years ago • 2 comments

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

  • NodeJS: 18.12.02
  • node-mssql: 9.1.1
  • SQL Server: 18.6

code4break avatar Feb 21 '23 13:02 code4break

Can you provide some replication code, please?

dhensby avatar Feb 21 '23 17:02 dhensby

Can you provide some replication code, please?

I will create a public repo for that.

code4break avatar Feb 22 '23 07:02 code4break