>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