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/
