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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 differents between varchar an nvarchar

Author  Topic 

shifis
Posting Yak Master

157 Posts

Posted - 2006-04-10 : 13:55:15
What is the diferent between varchar an nvarchar?

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-04-10 : 14:00:56
shifis,

U may read about this in detail, in Books OnLine - The help feature of SQL server.

Srinika
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-04-10 : 14:10:32
Since this is the "New to SQL Server" forum, I'll provide a little more detail than just BOL as the answer. The nvarchar, nchar, and ntext data types support unicode characters. You'll need to use those data types if you play on storing languages such as Japanese, Chinese, etc... Unicode supports a wider range of characters.

Tara Kizer
aka tduggan
Go to Top of Page

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-04-10 : 14:17:50
Tara,
Shifis has been in this forum for a while and should be more familiar with using BOL and other sources

However here is a more detailed description
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_dataencoding.asp


Srinika
Go to Top of Page

shifis
Posting Yak Master

157 Posts

Posted - 2006-04-10 : 14:29:08
Thanks for your help
Go to Top of Page
   

- Advertisement -