The TEXT field is going to use 80 characters of space for each field. The NOTE field is going to use 20 chars minimum for each field I would suggest the VARCHAR type over the NOTE in this instance
Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fogelson, Steve Sent: Tuesday, September 02, 2003 1:50 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Table Design I am new to this list. If I have 8 text fields that I want a table to have, would it be better to use 8 Note fields vs. 8 Text fields of 80 characters? Would the Note fields use less disk space that the allocated Text fields of 80 characters? I know this would allow me to use more than 80 characters in some of the fields, so that would be a benefit. Are there any draw backs to a Note field? Also, will I lose any data in a Text field that I convert to a Note Field? Thanks Steve Fogelson Internet Commerce Solutions
