What is the datatype to store boolean value in MySQL?

c# mysql types sqldatatypes
Deviprasad Das picture Deviprasad Das · May 13, 2011 · Viewed 12.4k times · Source

Possible Duplicate:
Which MySQL Datatype to use for storing boolean values?

I am a .NET programmer and using MySQL database for the first time in my life.

I wanted to store boolean value, MySQL has BIT, but the .NET conversion of this datatype is UINT64.

There is another datatype TINYINT(1), whose .NET equivalent is System.Boolean which will serve my purpose.

But why will I use TINYINT(1) (which can store value like 123, 22) instead of BIT, and it will take more space than BIT also (I guess)? It may be legal to use it but I dont think it is etical.

Can someone please help and clarify my doubt?

Answer

Kristoffer Lindvall picture Kristoffer Lindvall · May 13, 2011

MySQL have BOOL and BOOLEAN, but they are synonyms for TINYINT(1). A value of zero is considered false. Nonzero values are considered true. I guess someone at MySQL thought about it and decided TINYINT(1) is the preferred way to go. I've always used that myself.

There's some more info in this similar question: What is the difference between BIT and TINYINT in MySQL?

Related questions

Configuration System Failed to Initialize

I'm new to Visual Studio. I'm currently creating a Login form. I have this code. string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; try { using (OdbcConnection connect = new OdbcConnection(connectionString)) { connect.Open(); OdbcCommand cmd = new OdbcCommand("SELECT username, password FROM receptionist", connect); …

Read More
How to connect to MySQL Database?

New to C# programming, I'd like to be able to access MySQL Databases. I know MySQL connector/NET and MySQL for Visual Studio are required for C# development. Do I need to install them into my app? Is it possible …

Read More
Index (zero based) must be greater than or equal to zero

Hey I keep getting an error: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. My code: OdbcCommand cmd = new OdbcCommand("SELECT FirstName, SecondName, Aboutme FROM User WHERE UserID=1", …

Read More