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