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

Home -> Community -> Usenet -> c.d.o.server -> char versus varchar datatype

char versus varchar datatype

From: Frank Leenders <ftleenders_at_hotmail.com>
Date: Wed, 17 Feb 1999 09:49:30 +0100
Message-ID: <7ae06t$9m9$1@zonnetje.NL.net> 





Hello all,


this question probably has been asked before, but I missed the answer.
What arguments are there for the choice between a CHAR field in a table and
a VARCHAR datatype?


Of course, varchar has a variable length and that means less used space. On
the other hand a length byte is added and maybe it takes more time to find
the correct column in a block when all fields have a variable length. Or
.......?


Thanx


Frank


Received on Wed Feb 17 1999 - 02:49:30 CST












Original text of this message













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