Re: Doubt about TINYINT type

2004-04-28 Thread Don Read
On 27-Apr-2004 Paul DuBois wrote: At 13:29 -0400 4/27/04, Keith C. Ivey wrote: On 27 Apr 2004 at 13:59, Ronan Lucio wrote: OK, I understood it, but I didn´t understand why is there an option TINYINT(n) See http://dev.mysql.com/doc/mysql/en/Numeric_types.html | Another extension is

Doubt about TINYINT type

2004-04-27 Thread Ronan Lucio
Hi, If I create a column with the type TINYINT(2) UNSIGNED. Will the content can have the value minor than 510 (like a number 499), or will the content can have two values minor than 255 (like 11)? Thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Doubt about TINYINT type

2004-04-27 Thread Paul DuBois
At 11:53 -0300 4/27/04, Ronan Lucio wrote: Hi, If I create a column with the type TINYINT(2) UNSIGNED. Will the content can have the value minor than 510 (like a number 499), or will the content can have two values minor than 255 (like 11)? I don't know what minor than means, but TINYINT is a

Re: Doubt about TINYINT type

2004-04-27 Thread Ronan Lucio
Paul, I don't know what minor than means Sorry by my english. I´d like to say less than (or something like this). , but TINYINT is a single-byte type. The range for TINYINT is -128 to 127, and the range for TINYTINT UNSIGNED in 0 to 255. OK, I understood it, but I didn´t understand why is

Re: Doubt about TINYINT type

2004-04-27 Thread Keith C. Ivey
On 27 Apr 2004 at 13:59, Ronan Lucio wrote: OK, I understood it, but I didn´t understand why is there an option TINYINT(n) See http://dev.mysql.com/doc/mysql/en/Numeric_types.html | Another extension is supported by MySQL for optionally | specifying the display width of an integer value

Re: Doubt about TINYINT type

2004-04-27 Thread Paul DuBois
At 13:29 -0400 4/27/04, Keith C. Ivey wrote: On 27 Apr 2004 at 13:59, Ronan Lucio wrote: OK, I understood it, but I didn´t understand why is there an option TINYINT(n) See http://dev.mysql.com/doc/mysql/en/Numeric_types.html | Another extension is supported by MySQL for optionally |