At 02:35 AM 2/5/2003 -0500, Steve Johnson wrote: >Recently, I created a simple mailing database of 2200 names using >data imported from an Excel spreadsheet. I let Rbase create the new >table. All executed fine. However, I noticed that all of the data fields >were "note" type. I changed all the "note" fields to "Text" fields with >sufficient length to accommodate the information. Curiously, the total >file size increased after the change. I believe a packed both databases. >Since this database will function with only one table, what is the >downside of leaving the fields as "note" data type. There will be sorts >according to one or more fields to print labels.
Steve, Technically, NOTE field holds "variable length" text of up to 4,092 characters which is the limit of a row. The actual length of each NOTE entry is determined by the data contained in the column. R:BASE reserves a minimum of four bytes of internal storage space. Optionally, you may specify the maximum size of a NOTE data type, NOTE (n). The NOTE data type will truncate at (n) characters and a -Warning-. Hope that helps! Very Best Regards, Razzak.
