SQL Server Performance

what are the advantages of using char over Varchar

Discussion in 'General Developer Questions' started by s_niladri, Apr 8, 2006.

  1. s_niladri New Member

    Hi ALL,
    I know the basic difference between char and varchar datatype.
    In my interview the interviewer asked me what are the advantage
    of using Char over Varchar in SQL Server.

    I couldn't give the answer.

    So can any one tell me the advantages of using charinstead of varchar
    and in which situation it is useful.

    Please treat this as urgent basis

    my personal email id : s_niladri@yahoo.co

    Regards
    Niladri Saha
  2. dineshasanka Moderator

Share This Page