Sunday, February 19, 2012

help


what is the exact differnece char and varchar in inputwise means(which
one take alphabets and numerics)?
*** Sent via Developersdex http://www.examnotes.net ***Allowed data is the same for both, the difference between them are the
length of the input.
Examples:
DepartmentId dataset
Aabbaa, aabbbb, aabbcc, aabbdd, aabbee.
Expected data is always 6 characters therefore use char - eg char(6).
FirstName dataset
Andrew, Melody Suk Man, Allan, Cathy, Arthur, Shirly, Anthony, Wendy
Expected data can be any length in character therefore just put an
upperbound on it and use varchar - eg. Varchar(30)
Mel

No comments:

Post a Comment