views:

40

answers:

2

This stems from a question I had about nvarchar and varchar.

According to MSDN, varchar is:

...non-Unicode character data...

I've looked around for a clear definition of "non-unicode" but haven't had any luck. Is this the same thing as ASCII? If so, is there a reason that they don't just say ASCII?

+1  A: 

No. It's not the same. LATIN1 is an example of a charset that's not UNICODE and is not ASCII either. Here is a list of charsets.

Pablo Santa Cruz
+5  A: 

No, it is not the same thing and that's the reason why they didn't just say ASCII. There are many encodings out that are neither Unicode nor ASCII like Windows 1251 also known as CP1251 (cyrillic).

Darin Dimitrov
So "non-unicode" could be ASCII or Windows 1251 or any number of other encodings?
Abe Miessler
Yes, that's right, and that's why Unicode is preferred today.
Darin Dimitrov