RE: SQL Help: nvarchar vs varchar

Microsoft SQL Server Help ... F1 .. "Unicode Data Traditional non-Unicode data types in Microsoft(r) SQL Server(tm) 2000 allow the use of characters that are defined by a particular character set. A character set is chosen during SQL Server Setup and cannot be changed. Using Unicode data types,

SQL Help: nvarchar vs varchar

Hi, I am trying to upsize an Access 97 database to SQL Server 7.0 and in the access database I have a few text fields with a size of 255.  When I convert it to SQL Server, the text fields become nvarchar with a size of 255.  Is there any difference in using nvarchar or varchar?  I just started t