I'd advise char due to the over head and space usage of varchar. if its
something like your example i.e.16 chars, make it 30 to be sure.
Jerry
ps. + pps. = http://www.mysql.com/doc/en/Column_types.html
----- Original Message -----
From: "Dan" <dannycrompton@stripped>
To: <mysql@stripped>
Sent: Sunday, June 01, 2003 2:53 PM
Subject: Using varchar or something else?
I have used varchar for ALL my fields as this is the only one i know.
Alot of my rows just contain image link text ie.
/image/logoa.gif
Is using varchar overkill for these fields?. Would i be better using
something else?
Any advice?
TIA
Dan
ps. for my row which contains numbers it seems i can use either numeric or
int ? What's the difference, which should i use?
pps. is there a list which specifys all options and their uses?
