Last post Mar 16, 2016 05:56 AM by sandeepmittal11
Mar 15, 2016 09:57 AM|shivani.gupta|LINK
What is difference between char(1) and varchar(1)
Mar 15, 2016 01:10 PM|Mikesdotnetting|LINK
There isn't one, practically speaking.
Mar 15, 2016 01:27 PM|Rion Williams|LINK
Storage-wise, the difference between CHAR(1) and VARCHAR(1) are negligible as they are both going to allow for a single character to be stored.
There is going to be a minor difference here between the two in that the actual stored size (in bytes) will differ. A CHAR is going to only take up the number of bytes it is fixed as, so in this case a CHAR(1) will take up 1 byte, however a VARCHAR is going
to take up its length + 2 bytes, so a VARCHAR(1) would occupy 3 bytes. You can
read about this within the Arguments section of this MSDN article.
Generally, you will want to use VARCHAR if you know that the size of your content is going to vary from 1-N, however if it is a fixed size, CHAR might be the better option.
Mar 16, 2016 02:05 AM|wmec|LINK
VARCHAR is variable-length.
CHAR is fixed length.
If your content is a fixed size, you'll get better performance with CHAR.
Mar 16, 2016 05:56 AM|sandeepmittal11|LINK
Refer below post: