Albert, I think I would probably back your memory over mine :-)
The 4.5 manual is not clear - it just says a minimum of 4bytes. Regards Clive Williams ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 21, 2002 2:07 AM Subject: Re: Changing Column size in Database Part 2 > My memory says multiples of 2 bytes, 4 minimum. - eg 4,6,8, etc. > > "Clive Williams" <[EMAIL PROTECTED]> wrote: > > >Richard, > > > >This may have changed since 4.5 but I think that the space text colums take > >up progresses in multiples of 4 (1-4 chars = 4 bytes, 5-8 chars = 8 bytes > >.... 29-32 chars = 32 bytes. If this is the case you would not take up any > >more space if the size was 32 chars. > > > >FWIW > >Clive Williams > >CRW Services > >Sydney > >Australia > >----- Original Message ----- > >From: "Richard Starkey" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Thursday, June 20, 2002 6:53 AM > >Subject: RE: Changing Column size in Database Part 2 > > > > > >> Hi Sami, > >> > >> I guess I'm always looking for the easy way out. I finally decided not to > >> change the column size since there are only 400 rows out of 150,458 with > >> column size longer 30 chars. They will just have to be truncated. > >> > >> Thank you for your reply > >> > >> Richard (Ringo) Starkey > >> > >> -----Original Message----- > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > >> Behalf Of Sami Aaron > >> Sent: Wednesday, June 19, 2002 3:01 PM > >> To: [EMAIL PROTECTED] > >> Subject: Re: Changing Column size in Database Part 2 > >> > >> > >> Richard, > >> > >> You cannot update the column size in the Sys_Columns table. If you LIST > >> TABLE Sys_Columns you will see that it has a READONLY flag. > >> > >> While it's a PITA to have to rename the column in order to change the > >size, > >> the fact that R:BASE is forcing your column-name constraints within the > >> relational database structure is really a good thing! > >> > >> Sami > >> > >> ----------------------------------------------------------- > >> Sami Aaron > >> Software Management Specialists > >> 19312 W 63rd Terr > >> Shawnee KS 66218 > >> 913-915-1971 > >> http://www.softwaremgmt.com > >> > >> > >> ---- Original Message ----- > >> From: "Richard Starkey" <[EMAIL PROTECTED]> > >> To: "Rbase-L" <[EMAIL PROTECTED]> > >> Sent: Wednesday, June 19, 2002 12:40 PM > >> Subject: Changing Column size in Database Part 2 > >> > >> > >> > Hello again, > >> > > >> > After thinking about my previous question this question comes to mind. > >> > Could the column size be changed in the Sys_Column table for each table > >in > >> > order to circumvent the ERROR? > >> > > >> > Thanks, > >> > Richard (Ringo) Starkey > >> > > >> > > >> > ================================================ > >> > TO SEE MESSAGE POSTING GUIDELINES: > >> > Send a plain text email to [EMAIL PROTECTED] > >> > In the message body, put just two words: INTRO rbase-l > >> > ================================================ > >> > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >> > In the message body, put just two words: UNSUBSCRIBE rbase-l > >> > ================================================ > >> > TO SEARCH ARCHIVES: > >> > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >> > > >> > > >> > > >> > >> > >> ================================================ > >> TO SEE MESSAGE POSTING GUIDELINES: > >> Send a plain text email to [EMAIL PROTECTED] > >> In the message body, put just two words: INTRO rbase-l > >> ================================================ > >> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >> In the message body, put just two words: UNSUBSCRIBE rbase-l > >> ================================================ > >> TO SEARCH ARCHIVES: > >> http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >> > >> > >> ================================================ > >> TO SEE MESSAGE POSTING GUIDELINES: > >> Send a plain text email to [EMAIL PROTECTED] > >> In the message body, put just two words: INTRO rbase-l > >> ================================================ > >> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >> In the message body, put just two words: UNSUBSCRIBE rbase-l > >> ================================================ > >> TO SEARCH ARCHIVES: > >> http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > >================================================ > >TO SEE MESSAGE POSTING GUIDELINES: > >Send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: INTRO rbase-l > >================================================ > >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: UNSUBSCRIBE rbase-l > >================================================ > >TO SEARCH ARCHIVES: > >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > __________________________________________________________________ > Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ > > Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
