i.e.16 chars, make it 30 to be sure "it" = CHAR
----- Original Message ----- From: "Jerry" <[EMAIL PROTECTED]> To: "Dan" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, June 01, 2003 3:10 PM Subject: Re: Using varchar or something else? > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
