WmZilla - Webmaster and Marketplace

The Next Generation Webmaster and Trade Forum

int(3) Saved Despite Being 2147483647

Kishyong

New member

0

0%

Status

Offline

Posts

35

Likes

0

Rep

0

Bits

185

3

Months of Service

0%
Friends, when setting a table as int(3), does it not capture 3-digit numbers? I have a script that I prepared. It seems like the script is finished. I was testing it. I entered a value like 77777777777777777 to prompt an error message to display on the screen, but it was successfully added to the database. :confused: I checked in PHPMyAdmin. It stored it as 2147483647. I know that when a table is set as int(), it can hold a maximum value of 2147483647, but why did my int(3) setting have no effect? Does the number in the parentheses not matter? Many articles I read said there can be as many digits as the number inside the parentheses. So, in this case, it should either store or give an error for a maximum of 999. My mind is muddled at this late hour, I can't think anymore. Maybe I'm missing a very small detail, but what....
 

249

6,622

6,642

Top