RE: Varchar2....is this Dilbert or what?????

Let's try for accuracy on this board.

To be exact, mauve has the most RAM.

-----Original Message-----
From: Bill Noyes [mailto:WNoyes_at_delmarmedical.com] Sent: Thursday, May 11, 2000 6:17 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Varchar2....is this Dilbert or what?????

Because Mauve has the most memory right? I loved that one!

> -----Original Message-----
> From: Robert Jenkins [SMTP:rojenkin_at_district.vannet.k12.wa.us]
> Sent: Tuesday, May 09, 2000 3:48 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Varchar2....is this Dilbert or what?????
>
> Wow, your head honcho is a cartoon character. An ignorant one at
> that.
> But you can be diplomatic and tell them that increasing a varchar2
> column
> is no problem. But decreasing will cause data corruption. No that
> won't work
> cuz then they'll just want to make everything varchar2(4000).
> If the person doing the database design can't convince them that a
> flag column
> should be varchar2(1) then find a different designer. By the way I
> have a Muave database
> your head honcho might be interested in.
>
>
> >>> Christine Turner <christine.turner_at_ips-sendero.com> 5/9/00 3:04:15
> PM >>>
> Ok, forgive me if I offend anyone....but the head honchos came and
> asked
> what the ramifications would be if we were to make every, yes EVERY
> varchar2 column in new database the length of 255. The reasoning
> behind
> this is...."to keep maintenace down in the future, so we don't have to
>
> change the database every time when need a column resized". I'm
> fairly new
> to being a database administrator (going on a year), but I have been
> working in Oracle for about 6 years and quite frankly this sounds
> totally
> obsurd! Anyone have any comments??? Pro's, Con's????
>
> Thanks In Advance,
> Christine Turner
> FTP Database Administrator
> IPS Sendero
> Phone: (800) 321-6899 ext. 3286
> Fax: (480) 946-8224
> E-mail: christine.turner_at_ips-sendero.com
>
>
> --
> Author: Christine Turner
> INET: christine.turner_at_ips-sendero.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Author: Robert Jenkins
> INET: rojenkin_at_district.vannet.k12.wa.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Author: Bill Noyes
  INET: WNoyes_at_delmarmedical.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may