sqlsever

Posted by pandianmr-871 under ASP.NET on 12/14/2008 | Views : 1324 | Status : [Member] | Replies : 3
what is the differense char and varchar and nvarchar in microsoft sqlserver




Responses

Posted by: Amatya on: 5/30/2015 [Member] Silver | Points: 25

Up
0
Down
Nice explanation

Feel free to share informations 9731764134
mail Id ' adityagupta200@gmail.com
Thanks

pandianmr-871, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sheonarayan on: 5/30/2015 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
Here is complete list of different data type and their length and limits http://techfunda.com/Howto/sql-server/84/data-types-uses.

Thanks, hope it helps.

Regards,
Sheo Narayan
http://www.dotnetfunda.com

pandianmr-871, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Poster on: 12/14/2008 [Member] Starter

Up
0
Down
char are fixed length strings with a set length specified. If a string is less than the set length, then it is padded with extra characters so that it's length is the set length.

varchar are variable length strings with a maximum length specified. If a string is less than the maximum length, then it is stored verbatim without any extra characters.

nchar and nvarchar are similar to char and varchar, but they are used to store Unicode data (using the UNICODE UCS-2 character set). UNICODE requires two bytes per character, and allows the storage and retrieval of script based languages, such as Thai, Chinese, Japanese, etc.

pandianmr-871, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response