ERROR. The specified data type is not valid. [Data type (if known) = varchar]

Question

I recently installed SQL 2008 R2

CREATE TABLE TPERSONS( personid int PRIMARY KEY NOT NULL, lastname varchar(50) NULL, firstname varchar(50) NULL, salary money NULL, managerid int NULL -- foreign key to personid ) 

I do not understand why I am getting this error.

 Major Error 0x80040E14, Minor Error 26302 ) The specified data type is not valid. [ Data type (if known) = varchar ] 

Answer 1

The varchar data type is not supported in SQL Server CE . You must use nvarchar .