On Sun, 1 Jun 2003 14:53:54 +0100, Dan wrote: > 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?
It depends. We would need a lot more information about your data and application before we could make any meaningful suggestions. > 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? Numeric type (really is decimal type): An unpacked floating-point number. Behaves like a CHAR column: ``unpacked'' means the number is stored as a string, using one character for each digit of the value. The decimal point and, for negative numbers, the `-' sign, are not counted in M (but space for these is reserved). If D is 0, values will have no decimal point or fractional part. The maximum range of DECIMAL values is the same as for DOUBLE , but the actual range for a given DECIMAL column may be constrained by the choice of M and D. If UNSIGNED is specified, negative values are disallowed. If D is omitted, the default is 0. If Mis omitted, the default is 10. Prior to MySQL Version 3.23, the Margument must include the space needed for the sign and the decimal point. Int type: INT[(M)] [UNSIGNED] [ZEROFILL] A normal-size integer. The signed range is -2147483648 to 2147483647 . The unsigned range is 0 to 4294967295. So yes there is a difference. > pps. is there a list which specifys all options and their uses? The manual? Which was installed along with MySQL. /usr/local/mysql/manual.txt /usr/local/mysql/manual.html or where ever you install location is. Or at: http://www.mysql.com/doc/en/Column_types.html --- Listserv only address. Jeff Shapiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
