My normal preference is integer. This will also help if you need to expand past four states, or if you need to create access through ODBC - integers are the most common Primary Keys.
"Atrix Wolfe" <[EMAIL PROTECTED]> wrote: >Hello > >I was wondering for preformance, which would be better to have for a >column which has 4 possible states(1,2,3,4 vs A,B,C,D) ? �Would it be >text (1) since a char takes up 1 or 2 bytes (depending on if its unicode >or not...not sure how rbase stores it) or would it be integer (4 >bytes?). > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
