Skip to content

Sql: Specify parameter type when passing parameters to the sql conn #475

Description

@gledis69

Currently, sql server errors out when passing a null value for a varbinary column.
The problem is exactly due to this:
https://stackoverflow.com/questions/29254690/why-does-dbnull-value-require-a-proper-sqldbtype

Most column types will accept a string null and the db will automatically infer our intention, but for varbinary in MsSql the db complains that it cannot convert varchar to varbinary.

Metadata

Metadata

Assignees

Labels

mssql pgsql mysqlan issue that applies to all relational databases, same as labeling with `mssql` `mysql` and `pgsql`

Type

No type

Projects

Status
Done

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions