Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Tools General

Diffrence Between Varchar and NVarChar

I was just wondering what the diffrences are between NVARCHAR and VARCHAR? When do I use NVARCHAR as opposed to VARCHAR?

Thanks,
Matthew

[150 byte] By [Mulktide] at [2008-2-5]
«« text with style (Word 9.0 interop)
»» How to add button to toolbar similar as Find button in Outlook?
# 1
Hi Matthew,

nvarchar is for unicode strings and varchar for non-unicode strings.

HTH,
SvenC

SvenC at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 2
Unicode (nvarchar) has the capability to store characters from all languages, while varchar typically uses a local code page and can only use local characters.

SQL Server uses 2 bytes per character for n-type text columns, while the not-n-type columns use 1 (at least for latin-based languages).

Most of the time, nvarchar/nchar/ntext is the way to go.

-Ryan / Kardax

RyanLamansky at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Tools General...
SQL Server
SQL Server Tools General

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified