« The last weekend before you headed to Europe. | Main | Friday is coming closer and I am slowly feeling the affect of it. »

Differences between varchar and nvarchar in SQL Server

I was reading the news that is when I ran into this article. I didn't know the difference till this morning but I know now. I should know but unfortunately I didn't.

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. Its 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.

Post a comment

Type the characters you see in the picture above.