Paul
Paul

Reputation: 608

How can I set bit column to null?

The following only wants a primitive boolean (true or false).

 psmt.setBoolean(5, boolean) ; //wants primitive

What if I want to set the bit to null?

Sql server =

[bit] NULL

Upvotes: 1

Views: 1574

Answers (1)

Reimeus
Reimeus

Reputation: 159844

You could use setNull

preparedStatement.setNull(5, Types.BOOLEAN);

Upvotes: 4

Related Questions