Re: varchar2 and primary keys

Hello,

  Using Varchar over char always takes care of your memory...   see in char memory is static..(not usable if not filled) but in   Varchar it is dynamically allocated depending upon the value input   into the column...

  Defining Primary key for char or varchar doesn't make any difference   at all...It is only for memory consumption i think so..

  It is always advisable to use varchar b'cos when you are trying to   read the value from the column defined char doesn't give 100%   assurance that the complete info is read... one way i think this   is one of the reasons also....

  Hope this might help you....

From
Satish : somasatish_at_hotmail.com Received on Wed Sep 17 1997 - 00:00:00 CDT