Storing Boolean Values In SQL?

Question

I'm designing a SQL datbase table and a couple of the columns need to hold either a 1 or 0 (true or false). I define the columns to be of type binary(1), but now I don't know how to insert a true or false value into the database. inserting "true" or "1" doesn't work (it says either int or bool cannot be converted to binary)...

Answer 1

Use bit

This accepts the strings "true" and "false".

It also maps directly to the c# boolean type which is useful

Answer 2

Use the bit data type instead for your column. Then you can insert true/false directly.