Hi,
its not possible to fill an int(2) or greater field
with a value of more than 4 characters. I have
modified the file tbl_change.php to get the right size
of the input-textfield.
>so, shouldn't we, for int(2)
>- limit to 2
>- add a faq entry?
I don't think so because an int(2) only means the value
will be displayed with two positions if it is a simple
digit.
From the MySQL manual:
"This optional width specification is used to left-pad the
display of values whose width is less than the width
specified for the column, but does not constrain the range
of values that can be stored in the column, nor the number
of digits that will be displayed for values whose width
exceeds that specified for the column."
Loc
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=210714
Hi,
What was your goal by specifying int(2) ? According to
http://www.mysql.com/doc/C/o/Column_types.html
it means "maximum display size".
Please also read this:
http://marc.theaimsgroup.com/?l=mysql&m=100225445127759&w=2
so, shouldn't we, for int(2)
- limit to 2
- add a faq entry?
Don't forget that nobody else ever complained about this.
Logged In: YES
user_id=144058
Hi All!
>so, shouldn't we, for int(2)
>- limit to 2
>- add a faq entry?
I don't think so because an int(2) only means the value
will be displayed with two positions if it is a simple
digit.
From the MySQL manual:
"This optional width specification is used to left-pad the
display of values whose width is less than the width
specified for the column, but does not constrain the range
of values that can be stored in the column, nor the number
of digits that will be displayed for values whose width
exceeds that specified for the column."
Loc
Logged In: YES
user_id=210714
Fixed in the cvs for main branch.