Re: [Maria-discuss] int(x) does nothing

2013-05-15 Thread Michael Paulini
Oh it does. It is the display width of the integer, as you can read here http://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html in contrast to other databases where it is actually the data range. Michael 2013/5/15 Richard Couture > We discovered that declaring an int(x) of x char

Re: [Maria-discuss] int(x) does nothing

2013-05-15 Thread Kolbe Kegel
Hi Richard, On 15May , 2013, at 14:35, Richard Couture wrote: > We discovered that declaring an int(x) of x characters does not seem to > impose any restrictions what-so-ever on the size of data that can be stored > in that int. Storing an int of greater dimension than that which was declared

Re: [Maria-discuss] int(x) does nothing

2013-05-15 Thread Jesper Staun Hansen
Hi Richard, If I am not mistaken then I believe what you're looking for is this: http://dev.mysql.com/doc/refman/5.0/en/out-of-range-and-overflow.html -- 2013/5/15 Richard Couture > We discovered that declaring an int(x) of x characters does not

[Maria-discuss] int(x) does nothing

2013-05-15 Thread Richard Couture
We discovered that declaring an int(x) of x characters does not seem to impose any restrictions what-so-ever on the size of data that can be stored in that int. Storing an int of greater dimension than that which was declared does NOT even generate a warning. Can someone please tell us why we