phpMyAdmin doesn't like smallint

[chucklarge]

Hi,
I am using phpMyAdmin 2.6.0-rc2 to create a table with a field of unsigned smallint with a max size of 65535 but i keep getting an error that the max size is 255. What am I doing wrong? thanks chuck

Code: Select all

SQL-query:

CREATE TABLE `tabletest` (

`id` SMALLINT( 65535 ) UNSIGNED NOT NULL ,
PRIMARY KEY ( `id` )
)
MySQL said: 

#1074 - Too big column length for column 'id' (max = 255). Use BLOB instead

[chucklarge]

Ok I think i realized that it should be smallint(5) which is the number of characters and not the maximum value.