I have noticed that too, and have pretty much avoided that datatype. Perhaps someone knows how to define varchars so they don't act this way, but I just have not had the time or incentive to do any tests. The documentation is very slim on this kind of technical info.
Dennis McGrath --- Javier Valencia <[EMAIL PROTECTED]> wrote: > 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 > > > > > > > > > > > > --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
