Propery type for Bool values for datasets

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
KW
Posts: 125
Joined: Tue 19 Feb 2008 19:12

Propery type for Bool values for datasets

Post by KW » Tue 28 Oct 2008 01:21

Is there any mysql data type that will properly match to a bool value?

If not, what is the recommended data type for booleans?

Shalex
Site Admin
Posts: 8240
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 28 Oct 2008 08:31

We recommend to use the TINYINT(1) data type.

Please refer to http://dev.mysql.com/doc/refman/6.0/en/ ... rview.html , the "BOOL, BOOLEAN" section.

Post Reply