MS SQL (SQLSRV) INSERT null value

Question

MS SQL (SQLSRV) INSERT null value

Closed this issue 5 years ago · 1 comments

dotmra commented 5 years ago

Hi,

I am having a problem on 1.*
when I execute a query the NULL values becomes "" when binding values.

However MS SQL doesn't allow "" as an alias for NULL, it want NULL.

How can that be achieved?

Answer 1 · 2019-10-02T23:19:40.000Z

This should work as expected with escaped parameters. With that said, I seem to remember a driver setting or PDO property that needed to be set for NULL on FreeTDS / PDO. It has been a while since I have used MsSQL with PHP so I will have to look around for my notes to give you a definitive answer.