For database design, which of the following two options, will be better? What will be pros and cons?
1) For a field like 'Designation' using varchar(), and giving actual values like, Driver, Mechanic and Electrican. or 2) Using integer say, 1 for Driver, 2 for Mechanic and 3 for Electrician. -- H.S.Rai http://www.grex.org/~hsrai | Registered Linux User # 223684 http://counter.li.org/cgi-bin/runscript/display-person.cgi?user=223684 : ####[ GNU/Linux One Stanza Tip (LOST) ]####################### Sub : Simple console calculator (#2) LOST #222 A command line calculator which also understands precedence: Try :$echo "(12 + 2) / (5 + 2) ^ 2" | bc ### integer maths Or :$echo "scale=4; (17 / 3) + 0.517" | bc ### 'real' maths Note:'scale' is the decimal round off figure (real numbers). ####[bish (at) nde.vsnl.net.in]############################### : ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
