Re: tinyint issue

2001-03-27 Thread Lindsay Adams
On 3/27/01 10:08 AM, "Cal Evans" <[EMAIL PROTECTED]> wrote: > yep. That's the point of a tinyint, it only holds numbers 0-127. if you > need more then try smallint, int or bigint. (and please read the manual > regarding data types. It's clearly explained there.) > > Cal > http://www.calevans.co

Re: tinyint issue

2001-03-27 Thread Dan Nelson
In the last episode (Mar 27), Dacian Herbei said: > > I wonder if anyone had a problem like this one. I have created a > table with one field autoincrement. The field is tinyint(4). > whenever I try to introduce more then 127 records it refuses to > introduce them. I tried with ti

Re: tinyint issue

2001-03-27 Thread Paul DuBois
At 7:49 PM +0200 3/27/01, Dacian Herbei wrote: > Hi, > I wonder if anyone had a problem like this one. > I have created a table with one field autoincrement. The field is >tinyint(4). > whenever I try to introduce more then 127 records it refuses to >introduce them. > I tried w

RE: tinyint issue

2001-03-27 Thread Cal Evans
yep. That's the point of a tinyint, it only holds numbers 0-127. if you need more then try smallint, int or bigint. (and please read the manual regarding data types. It's clearly explained there.) Cal http://www.calevans.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PRO