difference between nchar and varchar datatype

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

difference between nchar and varchar datatype

Author

Topic

learning_grsql
Posting Yak Master

230 Posts

Posted - 2012-10-11 : 13:59:52

Hi,

I have always used both of them alternatively (nchar or varchar datatype) for columns with text values but I would like to know if there are any difference between them.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-10-11 : 14:05:14

nchar supports unicode data and is fixed width.

varchar doesn't support unicode data and is variable length.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources