C# and mysql bool problem!

Question

Hi,

I'm using a GridView with autogenerated columns, but it's not displaying a checkbox in a int with 1 length field...
Is there a type that I can use as boolean in mysql, so the GridView display it correctly ?

Thanks

---

http://BrunoZP.com.br || http://BrunoZP.com

Answer 1

In MySQL, BOOL or BOOLEAN are synonyms for TINYINT(1).

http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

http://usernamedenied.wordpress.com/2008/05/15/mysql-and-the-bool-data-type/

use this datatype.