Mike, Thanks. This info really helps. Some changes coming, but all for the good
Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 Off - 217-245-9504 Fax - 217-245-2350 Email - [EMAIL PROTECTED] Web - www.elmcity.org -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB Sent: Monday, January 14, 2008 4:56 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Data Types and File Gateway 2. More importantly, is there a basic rationale on when to use text, note, or varchar in various settings. Something like (I am making this up) text = editable/less than 250 characters, note = some editable/250-2000 characters, and varchar = not easily editable/over 2000 characters/pictures. 0 - 1500 chars TEXT 0 - 4092 Chars Note 0 - 256,000,000 Chars Varchar Pictures should be stored ad VarBIt not VarChar.. VarChar is editable and at present, all string manipulation routines are working against the datatype, so not easily editable no longer applies IMHO.
