Thanks for all of the replies, i see that integer is indeed superior to the single character (:
----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Saturday, January 18, 2003 5:52 PM Subject: [RBASE-L] - RE: text (1) vs. integer > 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/ >
