Re: VARCHAR2 vs. CHAR
From: mary kodama <mkodama_at_nyx10.cs.du.edu>
Date: 1996/11/22
Message-ID: <5743g3$2vp_at_nyx10.cs.du.edu>#1/1
Date: 1996/11/22
Message-ID: <5743g3$2vp_at_nyx10.cs.du.edu>#1/1
Yudong Sun <ysun_at_econnect.ca> writes:
>How efficient is VARCHAR2's implementation?
>Would I have a reason to prefer the use of CHAR for things like
>a person name (e.g., CHAR(50))? (I would use VARCHAR2 for things
>like file path - e.g. VARCHAR2(256).)
char(5) is five fixed characters, eg. 'ABC ', whereas varchar2(5) is variable length, upto five characters. eg. 'ABC' varchar is more efficient. I don't see any reason to use char unless you need fixed length fields.
-Mary Kodama Received on Fri Nov 22 1996 - 00:00:00 CET