Update sql bit field in database

Question

In a sql table I have a bit field and the value is displayed as True, when I update in code Update table1 set Active='True' it makes the update but the value is now displayed as 1 instead of True. How do I make it put the value 'True' instead of the integer in the table? Thanks.

What RDBMS and what is displaying the value as True and then 1? — Martin Smith
– Martin Smith, Commented Jul 29, 2011 at 23:29
it's seql version 10.50.1600.1, when i open the table to view the existing data the value is True in the Active(bit) field. Now when i do an update in management studio thru a query, it sets that value to 1. So my old value in the table is now 1 instead of True. — user282807
– user282807, Commented Jul 29, 2011 at 23:34

Martin Smith · Accepted Answer · 2011-07-29 23:37:48Z

15

Bits in SQL Server are always stored as 1 or 0 in a bitmap.

The "Edit Table" option in SSMS just translates this to True or False for presentation purposes, this is nothing to do with how it is actually stored.

answered Jul 29, 2011 at 23:37

Martin Smith

457k97 gold badges777 silver badges887 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user282807 Over a year ago

Was getting confused when doing a select query.

Martin Smith Over a year ago

@user - Yes. If you wanted it returned as a string you would need to do CASE Col when 1 THEN 'True' WHEN 0 THEN 'False' END or apply such formatting in the presentation layer.

Collectives™ on Stack Overflow

Update sql bit field in database

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related