Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: char vs. varchar in a data warehouse
I say make all char fields varchar2 no mater how long they are. It sure makes it easier for debugging later on, when the duhvelopers tell you that their code doesn't work and its b/c of a data type mismatch. Standards are paramount.
Gene
>>> lisa.yttri_at_cnh.com 06/05/02 11:53AM >>>
Hi -
We are in the process of building a data warehouse and data stores. This will be built on a Sun Solaris (2.8) machine running Oracle 9i R1. Estimates are approximately 180GB.
The developers have defined most of their small character fields as varchar2 - even the ones of size 1! They tell me that if the column does not have a value, they do not want to have to deal with a 'space' when manipulating that value.
Does this make sense? Should I be pursuing this further or shouldn't I care as the DBA?
Lisa
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: lisa.yttri_at_cnh.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: Gsais_at_co.palm-beach.fl.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).Received on Wed Jun 05 2002 - 11:13:25 CDT
![]() |
![]() |