I would like to create table to storage short text. What is the best type to use.
char varchar
but i can't guarantee the text length. Any best practice ?
A:
VARCHAR is the newer-style storage type for strings. Speaking from a MSSQL pov, VARCHAR offers many benefits over CHAR such as dynamic sizing, off-row storage for large values etc. I'd go with VARCHAR every time - unless I knew that the text was always going to be a fixed size.
Will A
2010-09-25 14:55:02
Ok, but what lenght should i put in declaration ?
chris
2010-09-25 17:46:43
The maximum length you foresee being stored in the field - plus 25% or so if you're not 100% confident in the size being correct.
Will A
2010-09-26 03:41:51
A:
If you are not sure about text length then i will suggest you should go with varchar.
you can just check,
Yogesh
2010-09-25 15:16:00
you can put the length whatever you want to be as max length. But varchar will only allocate that are required and not the max length. Max length only the upper limit for data storage. But before that you should also check the max limit that varchar can handle, you can not give more than that.
Yogesh
2010-09-26 06:30:45