ASP.NET Web Pages - Storing nvarchar more than 4000 character

Question

I'm using Microsoft WebMatrix to develop a small website in ASP.NET Web Pages. I have a database table with a column that may contain more than 4000 characters.

Nvarchar has a limit of 4000 characters. When using SQL Server I can just use Nvarchar(Max). Is there anyway I can do this using WebMatrix's database designer? Is it a limitation in the database and will I need to migrate it to SQL Server?

Just a side-question - does WebMatrix use a SQL Server Compact 4.0 database?

Many thanks for any help.

http://stackoverflow.com/questions/407521/what-are-the-limitations-to-sql-server-compact-or-how-does-one-choose-a-data — Hanlet Escaño, Feb 07 '12 at 19:48

score 3 · Accepted Answer · answered Feb 07 '12 at 19:47

3

SQL Server Compact is the default database for web matrix, http://www.microsoft.com/web/post/migrating-sql-server-compact-to-sql-server-express-with-webmatrix.

nvarchar(max) is not supported in SQL Server Compact, but you could use nText. However, I don't believe you can use an nText column in WHERE or GROUP BY clauses.

answered Feb 07 '12 at 19:47

Zach Green

3,421
4
29
32

Thanks for the link. I think I will migrate to SQL Server once my site is ready to be published. – Gareth Lewis Feb 08 '12 at 08:35

ASP.NET Web Pages - Storing nvarchar more than 4000 character

1 Answers1