Tinyint (boolean) data type? RSS

• • Reply
  

  spinmonkey

  Member

  190 Points

  46 Posts

  Tinyint (boolean) data type?

  Aug 25, 2003 04:46 PM|LINK

  I have not use mySQL very much. My current project interfaces with mySQL. I have a table storing boolean values as TINYINT, but when I query the database, the data does not return as an INTEGER. My cast always fails, unless I cast as BYTE. #1 - is this the correct return data type? #2 - how do I use it for switching purposes in my C# code? i.e. I can test the value in a n IF statement, to gate my code. #3 - if not, what data type should I cast to, and how do I do it? Thanks from the noob!
  ~o0 Mike Christian Oo~