|
What is difference between nchar & nvarchar
VARCHAR is an abbreviation for variable-length character string. It is a string of text characters that can be as large as the page size for the database table holding the column in question. The size for a table page is 8,196 bytes, and no one row in a table can be more than 8,060 characters. This in turn limits the maximum size of a VARCHAR to 8,000 bytes.
The N in NVARCHAR means uNicode. Essentially, NVARCHAR is nothing more than a VARCHAR that supports two-byte characters. The most common use for this sort of thing is to store character data that is a mixture of English and non-English symbols - in my case, English and Japanese.
Contributed by:
Guest
Guest user is that user who have done some activity on website without login. Activity contains commenting on any article, uploading an image on website etc.
Resourse address on xpode.com
http://www.xpode.com/Print.aspx?Articleid=158
Click here to go on website
|