Re: howto ignore whitespace in select query

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 03/26/04

  • Next message: San Tuon: "Re: howto ignore whitespace in select query" 
    Date: Fri, 26 Mar 2004 17:35:34 +0530

    hi san,

    Use varchar datatype this will take only storage space, of the actual length in bytes of the
    data entered.

    Use char datatype when the data values in a column are expected to be consistently close to
    the same size. For example Sex that is going to be 'F' or 'M'. or marital status like 'Single'
    or 'Married' etc.

    Use varchar datatype when the data values in a column are expected to vary considerably in
    size. 

    -- 
Vishal Parkar
vgparkar@yahoo.co.in
  • Next message: San Tuon: "Re: howto ignore whitespace in select query"