CODEWITHSUNDEEP
sql-server-ce
aherrick
aherrick

Reputation: 20161

SQL Server CE 4.0 Entity Framework Maximum Row Size Exception?

I have a simple database with 1 table and 8 columns. The table has about twenty rows in it. See the exact schema below. However when trying to insert certain records I get the following error:

The table definition or the row size exceeds the maximum row size of 8060 bytes.

Why would I be getting this. The table is not that big at all yet. What do you think?

enter image description here

Upvotes: 0

Views: 1457

Answers (1)

Program.X
Program.X

Reputation: 7412

nvarchar is Unicode and requires 2 bytes per character internally, so your nvarchar(4000) is actually 4000*2 bytes=8000. Add the rest ....

Upvotes: 1

Related Questions