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 > > > > > >
