"a record cannot cross page boundaries" has serious ramifications. In the worst case a record with the size of 51% of page length will leave 49% of the page unused. So one will have to think twise before adding a column to a table.

Kamil

>the 8060 is based on the page width. a record cannot cross page boundaries.
>
>Peter
>
>
>>>>I am slightly puzzled here. Are you saying that i can not declare char 8000 at all? If it is true then how to incorporate a char 8000 (or a wee bit less) column in a multicolumn table?
>>>
>>>I am not saying that at all. For example, the following will work:
>>>
>>>CREATE TABLE foo (
>>> a char(8000)
>>>)
>>>
>>>But this will not:
>>>
>>>CREATE TABLE foo (
>>> a char(8000),
>>> b char(60)
>>>)
>>>
>>>If you try it, you should get the following error:
>>>
>>>Creation of table 'foo' failed because the row size would be 8081, including internal overhead. This exceeds the maximum allowable table row size, 8060.
>>>
>>>My point was that there is overhead on the row that will probably prevent you from getting an actual row size of 8060 bytes.
>>>
>>>-Mike
>>
>>
>>Got it!
>>Best wishes
>>
>>Kamil