Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2002-09-14 : 06:36:47
|
| hello,I have a table with 6 nvarchar columns of size 2 columns of 3000 and four columns of 4000 ,now if i enter big records in the table which are less then the respective size of the fields it gives me the following error:"annot create a row of size 8157 which is greater than the allowable maximum of 8060.The statement has been terminated.""why do i get this error ?? i am not inserting records which are imore than 2000 characters in a column.is there some maximum limit for the size of the column????waiting..Harsh. |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-09-14 : 09:21:23
|
| There is a size limit for the row - 8000 characters (or 4,000 in using NVARCHAR). You've got 22,000 characters - way too much.You'll have to break it up into different rows or use the TEXT data type to store BLOBs |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-09-14 : 09:23:50
|
is the row size limited to 4000 for nvarchar or for a field of nvarchar???i am a bit confused over there!taking ntext also doesn't work! |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-09-14 : 09:27:39
|
| The maximum row size is 8k. nVarChar takes up 2 bytes for every character giving you a total row size of 4000. If one record is longer than that, your insert will fail.Damian |
|
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2002-09-14 : 10:46:40
|
| actually, MAX ROW LENGTH (in bytes): 8060and 60 bytes could store a lot of info... :) |
|
|
|
|
|
|
nvarchar size problem!! please help