what are the advantages of using char over Varchar | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

what are the advantages of using char over Varchar

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 : [email protected] Regards
Niladri Saha
If a column’s data does not vary widely in length, consider using a fixed-length CHAR field instead of a VARCHAR. While it may take up a little more space to store the data, processing fixed-length columns is faster in SQL Server than processing variable-length columns More infohttp://www.sql-server-performance.com/datatypes.asp —————————————-
http://spaces.msn.com/members/dineshasanka

]]>