max sizes of mysql tpes

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
pelegk2
Forum Regular
Posts: 633
Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:

max sizes of mysql tpes

Post by pelegk2 »

i have encountered a problem which made me clear that i dont execly understand to the end the defenitions in the mysql DB!
for example i hade a column defined as tinyint(3)
and when i had 255 rows
and tried to insert another one i got an error and didnt understand why!
how can i check what execlly is the max value of each type when talking in consideration fo course the length of the value?
thnaks in advance
peleg
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

Post Reply