Board index   FAQ   Search  
Register  Login
Board index php forum :: Database phpMyAdmin

phpMyAdmin doesn't like smallint

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: macek, egami, gesf

phpMyAdmin doesn't like smallint

Postby chucklarge » Thu Sep 30, 2004 4:38 pm

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
New php-forum User
New php-forum User
 
Posts: 3
Joined: Thu Sep 30, 2004 4:27 pm

Postby chucklarge » Thu Sep 30, 2004 6:34 pm

Ok I think i realized that it should be smallint(5) which is the number of characters and not the maximum value.
chucklarge
New php-forum User
New php-forum User
 
Posts: 3
Joined: Thu Sep 30, 2004 4:27 pm


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 0 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.