In SQL Server 2000, what is the difference between nvarchar and varchar?

SQL Server provides two data types to store character information. In SQL ServerProgramThe two data types are roughly the same. The difference is that nvarchar is used to store Unicode data that processes multilingual data in database charts. Other languages have a set of characters to saveCode. Because the extended character code of other languages needs to be stored, nvarchar occupies twice the space of varchar.

It is enough to store only one byte of English characters, but there are many Chinese characters and two bytes are required for storage. It is easy to cause confusion when both English and Chinese characters exist, unicode Character Set is generated to solve the incompatibility problem of character sets. All its characters are expressed in two bytes, that is, English characters are also expressed in two bytes.

# Database Technology