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 |
|
oahu9872
Posting Yak Master
112 Posts |
 Posted - 2006-01-09 : 10:23:56
|
| I am getting the following error when I try to insert into the database. Microsoft OLE DB Provider for ODBC Drivers error '80040e14'[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size 8208 which is greater than the allowable maximum of 8060The field size is set to hold 2,000 and I only inserted text totalling 178 characters. Any ideas would be appreciated... |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-09 : 10:49:27
|
| Try with a few characters, gradually increase and c when it starts failingAlso check whether ur text contain trailing spaces.Also what is the data type of ur column? varchar ? |
 |
|
|
oahu9872
Posting Yak Master
112 Posts |
Posted - 2006-01-09 : 11:01:09
|
| Yeah its varchar. I checked to see if I had copied a block of shite space out of Word but I hadn't. the word count said 7800 characters with spaces which should put me under 8000. I got it to work by taking out a block of the text, so its like I'm not getting the full amount of characters I should be able to. |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-09 : 11:10:18
|
| The word count doesn't take into consideration the Enter Keys etc. So that doesn't give a correct indication of real characters stored. Also ur first Q says that the text is 178 characters and for sure it should have been 7800.eg. Type ABCD, press Enter twice and type PQRS. Then copy and paste it inside quotes of the following in Query AnalyzerPrint len('')It would look like print len('ABCDPQRS')Execute this in QA and compare the result with wordcount in Word |
|
|
|
oahu9872
Posting Yak Master
112 Posts |
Posted - 2006-01-09 : 12:56:03
|
| I'll check and see what I come up with. Thanks |
|
|
|
|
|
|
SQL INSERT ERROR