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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-17 : 08:30:59
|
| writes "Why do get following message:Warning: The table 't1' has been created but its maximum row size (10025) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.If we replace the column datatype with text from varchar(2000) of one of the columns in the table, we can avoid this message.But again, we've read on one of the sites that using text datatype has its own problems. What are problems of text datatype with text columns.I tried inserting data in the table(created by using varchar(2000)) but the insert statement did't fail.Please let me know about the warning message and the problems associated with text datatype and possible solutions.ThanksVarsha" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-06-17 : 09:10:55
|
| SQL Server 7 and 2000 use 8K datapages. You cannot have a single row that spans multiple pages, therefor you have a limit to row size (8K - header). When you change your varchar(2000) to a text datatype, you are only storing a pointer to a blob on the datapage.The 'problem associated' with the text datatype will depend on what you are storing and how you expect to use it. Tell us more and maybe we can help you with your design.<O> |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-17 : 09:46:26
|
| As Page stated, text columns are stored separately from the regular data, and only a pointer to the text data is stored on the regular data page. The problems arise when trying to modify that data on a separate page; it is unstructured, unlike the rows and columns that exist on a regular data page.Think of trying to edit a Word document WITHOUT using the keyboard or mouse. It *can* be done using programming commands, but...WHOA! The code isn't that bad really, but you have to spell out which paragraph, which sentence, which word, and which letter explicitly. There's no simple command to just UPDATE something. |
|
|
|
|
|
|
|
|
Text datatype