So in C# whenever I retrieved a tinyint from my MSSQL database I used the following cast. (int)(byte)reader["MyField"]; However, that cast doesn't seem to work in MySQL. What I have tried (byt...

Which one is better, Tinyint with 0 and 1 values or ENUM 0,1 in MyISAM tables and MySQL 5.1?

I wanted to make a true/false field for if an item is in stock. I wanted to set it to Boolean ( which gets converted to tinyint(1) ), 1 for in stock, 0 for not in stock. I am getting feeds from v...

I have a status column in my database table. Type : tinyint(4) and the Default value is 0. I want to change the default value to 1. How to do that? May be this is a very simple question, but I don'...

I was designing a database for a site where I need to use a boolean datetype to store only 2 states, true or false. I am using MySQL. While designing the database using phpMyAdmin, I found that I h...

In Ruby on Rails, the following code in a migration creates a column of type tinyint(4) in MySQL: create_table :great_table do |t| t.integer :step_position, :limit => 1 #tinyint end How woul...

In which cases would you use which? Is there much of a difference? Which I typically used by persistence engines to store booleans?

I reverse engineered my database with symfony2 and doctrine with commands : php app/console doctrine:mapping:convert php app/console doctrine:mapping:import php app/console doctrine:generate:entit...

I realize that tinyint is a single byte integer (by the way, is it signed or unsigned?). What does the argument (3) signify? I've searched and couldn't find the answer.

I currently use enums as TINYINTs in MySQL database. My tables have a few million rows in them. We then map the enums from TINYINT to Strings elsewhere. I am considering storing these enums as Str...

I want to limit the datatype value that can be stored within a field to a specific range of integer values: [0,10]. On user input within a PHP script I validate and sanitise the data to make sure ...

What's the best practice for fields that hold true/false values? Such columns can be defined as enum('yes','no') or as tinyint(1). Is one better/faster than the other? Is it better to use enum('1...

Lets assume I want to save the count of datagrid rows which can be max. 24 because each row is 1 hour. To save the row index in the database a tinyint field would be totally enough. But back in my...

What's the most appropriate (read least data consuming) data field to store a true/false/1/0 value in a mySQL database? I have previously used a one character long tinyint, but I am not sure if it...

I am working on a project using asp.net mvc 2 and linq to sql. The problem occurs when trying to insert data into a table where the table has an identity column type of tinyint. When trying to inse...

If TINYINT can store three characters, for example, why can't it store up to the number 999?

MY PLATFORM: PHP & mySQL MY SITUATION: I came across a situation where I need to store a value for user selection in one of my columns of a table. Now my options would be to: Either declar...

Here's the problem. In MySQL's Connector/NET a TINYINT(1) field properly translates back and forth into a .NET bool value. If I select from a table with a TINYINT(1) column, everything is golden. H...