Top "Tinyint" questions

tinyint is one of the Exact number data types that use integer data.

BOOLEAN or TINYINT confusion

I was designing a database for a site where I need to use a boolean datetype to store only 2 states, …

mysql types boolean tinyint
What is the difference between BIT and TINYINT in MySQL?

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

mysql bit tinyint
MySQL Boolean "tinyint(1)" holds values up to 127?

I wanted to make a true/false field for if an item is in stock. I wanted to set it …

mysql boolean tinyint
Change tinyint default value into 1 mysql

I have a status column in my database table. Type : tinyint(4) and the Default value is 0. I want to change …

mysql database tinyint
TINYINT vs ENUM(0, 1) for boolean values in MySQL

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

php mysql enums tinyint
Which is faster: char(1) or tinyint(1) ? Why?

MY PLATFORM: PHP & mySQL MY SITUATION: I came across a situation where I need to store a value for …

mysql char tinyint
What does tinyint(3) mean in (SQLite) SQL?

I realize that tinyint is a single byte integer (by the way, is it signed or unsigned?). What does the …

sql sqlite tinyint
How to create a column of type tinyint(2) or tinyint(3) in Ruby on Rails?

In Ruby on Rails, the following code in a migration creates a column of type tinyint(4) in MySQL: create_table :…

mysql ruby-on-rails rails-migrations tinyint
How do I retrieve a data type of tinyint from MySQL in C#?

So in C# whenever I retrieved a tinyint from my MSSQL database I used the following cast. (int)(byte)reader["…

c# mysql tinyint
enum('yes', 'no') vs tinyint -- which one to use?

What's the best practice for fields that hold true/false values? Such columns can be defined as enum('yes','no') …

mysql boolean tinyint