I'm working on a project which has a requirement for a list box to be able to store up 7000 lines. I've defined the field in mysql as longtext and have validated that on the initial insert statement all 7000 lines are written to the db. However when retrieving the values and passing into a php variable the list is truncated to 585 lines. Please advise if there is a method for handling longtext results or if I will need to create a relational table and parse the items out on the row level.

Thank you,

Josh

    What version of MySQL are you using?

    Can you show us some code?

    A LONGTEXT field has a maximum length of 4GB (or the max packetsize or memory allowed on the server/client). Therefore, it really doesn't matter how many "lines" of data you have, but rather the size. I'm assuming, though, that you're not exceeding 4GB (or coming anywhere close to it).

      Write a Reply...