| Author: Venkat Tammineni 20 Nov 2008 | Member Level: Gold | Rating:  Points: 2 |
hi,
SQL Server provides both datatypes to store character information. For the most part the two datatypes are identical in how you would work with them within SQL Server or from an application. The difference is that nvarchar is used to store unicode data, which is used to store multilingual data in your database tables. Other languages have an extended set of character codes that need to be saved and this datatype allows for this extension. If your database will not be storing multilingual data you should use the varchar datatype instead. The reason for this is that nvarchar takes twice as much space as varchar, this is because of the need to store the extended character codes for other languages.
I hope this helps you.
Thanks
Venkat
|
| Author: Bunty 20 Nov 2008 | Member Level: Diamond | Rating: Points: 3 |
Hi,
The difference between varchar and nvarchar is that in case of nvarchar we can store unicode characters also means we can store characters of any language like hindi,telugu,urdu,french and so on.
Regards
S.S.Bajoria
Thanks & Regards
S.S.Bajoria
|
| Author: kiran 27 Nov 2008 | Member Level: Silver | Rating: Points: 6 |
VARCHAR is an abbreviation for variable-length character string. It's 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.
|