PDA

View Full Version : MySQL smallint(6)...


Maskime
03-28-2008, 06:52 AM
Watch out!

In the table phpdig_sites the column 'port' is a smallint(6) which bounds are [-37676; 37676]. So if you put a port above those limits (which was my case... (42232)) MySQL convert the port so that it can go into the column.
I've replace the smallint by a bigint and it's working fine now.