Tjop I know why you don't like the manual I was very happy with the book. :-)
I don't know how you say "exponent" in english but you can calculate it as follows
28 = 2222222*2
There are 4 types of int
tinyint = -128 +128 (28) (1 byte)
smallint = -32000 +32000 (216) (2byte)
medium int = - 8388608 +8388608 (224) (3 bytes)
int = -2147483648 + 2147483648 (4 bytes)
bigint = very big did not memorize the value but it is a few bilion
If you are sure you only use positive values put after the declaration the word "unsigned"
this makes a tiny int not -128 +128 but 255
Ex.
create table ex (
id int unsigned primary key auto_increment,
name char(30),
age tinyint unsigned
);
Now for you own tables
page_id tinyint unsigned
age tinyint unsigned
image_id tinyint unsigned or if >255 smallint unsigned
nib (very big - how big can it be?)
Don't know what nib means but if it must contain a lot of characters use blob
blob can contain 65536 characters
now, i'm really lost:
what about CHAR and VARCHAR?
what type should I use and what size is optimal for
char always takes up the space you give it. if you say char(30) it always uses 30 bytes. if you just say char it uses the maximum size of 255 characters.
Varchar looks how many chars are inserted. so if you say varchar(30) and you only use 5 characters it only uses 5+1byte (because it needs to know how big it is I think)
I personaly always use char because it searches faster and hd space is most of the time not the problem (and it's cheap)
To continue with you table
name char(50)
adress char(250)
(I think it is a little bitto big(250 character for an adres) but If you think you need it use it. I most of the time only need 40 to 50 characters in this field)
memo blob
biography blob
(blob can contain 65536 characters)
Well I hoped this helped a little bit :-)
Maarten
I just foud what you needed if you do not understand a ting I am saying
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html
And then go to chapter 7.3
