Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: NEWB question no. 1

Re: NEWB question no. 1

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Fri, 12 Jan 2001 13:34:33 -0000
Message-Id: <10739.126483@fatcity.com>


yes char requires more space. But there are reasons for using it, espcially with very small sizes... or fields that are input from outside systems and which have to match back to them....

I tend to use char for fields that are not null and either 1 or 2 characters in length.

>From: "Margaret" <chigarden_at_netzero.net>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: NEWB question no. 1
>Date: Fri, 12 Jan 2001 03:35:27 -0800
>
>Good morning all !
>
>Okay...here goes with question #1
>
>In reading and playing with SQL*PLUS I see that there is CHAR ( text
>strings
>that are padded to the length you set) and VARCHAR2 (text strings that are
>not padded). My question is why would one ever use CHAR ? It seems it
>would require MUCH more space
>
>thanks,
>Margaret Strother
>
>
>Shop online without a credit card
>http://www.rocketcash.com
>RocketCash, a NetZero subsidiary
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Margaret
> INET: chigarden_at_netzero.net
>
>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).



Get your FREE download of MSN Explorer at http://explorer.msn.com Received on Fri Jan 12 2001 - 07:34:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US