sqlsever

Posted by pandianmr-871 under ASP.NET on 12/14/2008 | Views : 2415 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

what is the differense char and varchar and nvarchar in microsoft sqlserver

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	Nice explanation Feel free to share informations. 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

0	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

0	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

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

Latest Posts