locked
not able to insert .. row size too large error RRS feed

  • Question

  • User-2135668640 posted
    Hi. I needing to create a SQL table that contain the input fields of the attached image of the form but will have 25 rows instead of the current 12. When the form is submitted it dumps into one SQL table row. When creating the table I receive the "Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs" error.
    Saturday, March 17, 2012 9:03 PM

All replies

  • User269602965 posted

    show code so forum members can help you.

    insufficient information

    Sunday, March 18, 2012 9:25 PM
  • User-1407477457 posted

    So you have 12 rows that add up to 65535 bytes?  What are your current datatypes and are you sure they need to be as big as they are?

    Sunday, March 18, 2012 9:38 PM