FYI. One thing I have noticed is that when I use varchar the overall size of the database grows considerably, so I assume that they carry quite a bit of overhead. When I converted the varchar columns to note, the database overall size was considerably smaller. Both sizes were measured after packing the database. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dennis McGrath Sent: Friday, March 26, 2004 12:32 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Note Data Type Varchars are stored in the RB4 table, thus the answer is no. --- [EMAIL PROTECTED] wrote: > While we are on the subject - does varchar act the same way as note - > is > it preferable to put it in a separate table to save space and guard > against data corruption??? > Also, if one sets a limit of characters in note, does it stay in the > row > or get spread out all over the place like an unlimited note? > Bob C. > > > Please respond to [EMAIL PROTECTED] > Sent by: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] (RBASE-L Mailing List) > cc: > Subject: [RBASE-L] - RE: Note Data Type > > Also, maximum width of a row in a table is 4092 characters. The note > field will expand only to what is left from that limit. > > I like to put note fields in a separate table with a foreign key link > to the master table. That way, I only use storage I need, and my > notes > can be over 4000 characters each. This will not change as the master > table is modified. > > Also I can have more than one note per row in the master table which > can be handy. > > In addition, if the master table gets corrupted, repair is lots > easier. > > Dennis McGrath > > > > --- Javier Valencia <[EMAIL PROTECTED]> wrote: > > Steve: > > Make sure that your note field is not defined as being 200 in > length. > > Right > > click on the table in question, select columns and check the length > > for this > > field. > > Javier, > > > > Javier Valencia, PE > > President > > Valencia Technology Group, L.L.C. > > 14315 S. Twilight Ln, Suite #14 > > Olathe, Kansas 66062-4578 > > Office (913)829-0888 > > Fax (913)649-2904 > > Cell (913)915-3137 > > ================================================ > > Attention: > > The information contained in this message and or attachments is > > intended > > only for the person or entity to which it is addressed and may > > contain > > confidential and/or privileged material. Any review, > retransmission, > > dissemination or other use of, or taking of any action in reliance > > upon, > > this information by persons or entities other than the intended > > recipient > > is prohibited. If you received this in error, please contact the > > sender and > > delete the material from all system and destroy all copies. > > ====================================================== > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > > Fogelson, > > Steve > > Sent: Thursday, March 25, 2004 10:15 AM > > To: RBASE-L Mailing List > > Subject: [RBASE-L] - Note Data Type > > > > I am trying to edit a Note data type column. I am trying to insert > > data into > > this field and it is only letting me put in 200 characters. > > > > I am editing while using the R:Base browse command and double > > clicking on > > the field. > > > > I thought this data type would got to over 4,000 characters. > > > > Thanks for any help. > > > > Steve Fogelson > > Internet Commerce Solutions > > > > > >
