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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
