Increase Template Character Limit

(3 posts) (2 voices)


  1. ajdjackson, Member

    Morning all

    Don't ask but I'm creating a report using a template and I've hit the MySQL TEXT datatype limit. Any chance upping it to MEDIUMTEXT? I change the datatype in the table but this didn't work.



  2. myDBR Team, Key Master

    MySQL TEXT can hold up to 64K data and a template consists of three of those (header, row and footer). How big is your template?

    It is not advisable to change myDBR's internal table definitions as this might lead into unexpected results when updates are done. Please contact support before making such changes.
    myDBR Team

  3. ajdjackson, Member


    I having to create reports from data that was exported as csv files from a retired enterprise system.

    Some of these csv files have circa 400 columns and the reports can be up to 15 pages.

    If you can imagine there is a lot of text in these reports, essentially questions, with the answers being pulled out of the db.

    So with html formatting and field pairs I have hit the 65K limit on 2 of the reports.

    I'm currently splitting those large reports over several templates now.




You must log in to post.