Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sreehari
Starting Member
37 Posts |
 Posted - 2006-05-22 : 10:40:39
|
| hicould any one help me in differentiating between varchar and nvarcharThanks in advance |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-05-22 : 10:46:27
|
| Read books online about "unicode data", "nvarchar and nchar" and "varchar and char".-------Moo. :) |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-22 : 11:02:36
|
| If you just need to store A-Z, 0-9 and basic punctuation then varchar will do.varchar MAY do for simple foreign accents etc.For Japanese / Chinese / etc. type characters you need unicode, and for that you need Nvarchar.Nvarchar uses 2 bytes for every character - so twice as much storage space as Varchar. So you should only use it when the data being stored requires it.Kristen |
|
|
|
sshelper
Posting Yak Master
216 Posts |
|
|
muralikrishna
Starting Member
1 Post |
Posted - 2009-12-07 : 05:36:04
|
| simply speaking............varchar is used for english language. where as nvarchar is used for non-english language.muralikrishna |
|
|
|
|
|
|
Diff between varchar and nvarchar