title: Best DataType to store Isdeleted column
body: <p>I want to add a new column for Isdeleted which can have two values Yes Or No. so which data type is best to use:-</p>
  
  <ol>
  <li><p>to use char(1) and store two values Y or N.</p></li>
  <li><p>Bit. and store 1 or 0 . then i can on the application level to say that 1 means Yes and 0 means No.</p></li>
  <li><p>varchar(3). and store Yes or No in the database , without the need to handle the display on the application level ?</p></li>
  </ol>
  
  <p>i am confused abotu which dataTpe to use, and how to balance between storage used (best if Bit) and simpliciy (when using char(3)).</p>
  
  <p>Best Regards</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>i tried Bit but when i manually insert 1 or 0 inside the Sql server database i got the following error:-Invalid value for cell (row 42, column 17). The changed value in this cell was not recognized as valid. .Net Framework Data Type: Boolean Error Message: String was not recognized as a valid Boolean."" </p>