I would like to create a table in memory short text What is the best type to use
Four things
But I can not guarantee the length of the text. Any best practice?
VARCHAR
is the new-style storage type for strings. Speaking from MSSQL POV, provides more benefits than VARCHAR
CHAR
such as dynamic sizing, off-straw storage for large values and more. Every time I go with VARCHAR - as long as I knew that the text was always going to be a fixed size.
Comments
Post a Comment