maximum row size 2

[mttorpy]

I am having proplems when I run a SQL statment were I get this error.

Warning: The table 'dja_master_report' has been created but its maximum row size (8343) 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.

I guess the error is pretty self explanitory but I do not know how to get around it as I need all the data I am asking for.

 

[ClaireHCM]

You might want to do research on the field content. If one table couldnt fit all the information. You might think about referencial integrity to seperate the information into 2 or more tables, while retriving data, do join to access data from multiple tables.

 

[mrdenny]

See if you can shrink the deffination of some columns. If you have a varchar column that is large, but you don't need to be able to search against it, you can change that to a text field.

This will allow you to put as much data into the table as you need, but will help you stay away from the 8060 limit.

Feel free to post your create table code, and I'll take a look at it, and post any sugestions that I have.

Your other option is to break your table into two tables. With a 1 to 1 relationship. It's a pain to have to do that though.

Denny

--Anything is possible. All it takes is a little research. (Me)