Okay
  Public Ticket #3133117
Text field length
Closed

Comments

  • Michael Helms started the conversation

    Hello, I'm interested in finding out if there's a way for tables that are built in wpDataTables to accommodate text that is more than 240 characters in length. I know that it can't be unlimited ... but something closer to 1,000 or even 2,000 bytes would be helpful to me.

  •  1,851
    Miloš replied

    Hi, Michaelsmile.png

    Thanks for reaching out to us.

    -

    Yes. I believe that you should not have issues in achieving  this with our tables.

    It depends on the table types that you would use.

    -

    For example, if you are making a new table in the database, a Manual table,

    then you can choose the data type for string columns that will be created in the new database table.

    If you choose a "one-line string" in our plugin's column settings, when the new String column is added to a Manual table,

     the default limitation will be as VARCHAR( which has a limitation of 255 characters) . 

    -

    Or if you set the string column to be "multi-line string", then it will make a  TEXT column in the database table ( 65,535 character limit)

    -

    2.

    Alternatively, if there is already an existing table in the database, that has a string column set as a TEXT type, in your database management tool ( e.g PhPMyAdmin), 

     then if you make an SQL Query table in our plugin,

    it will already be pulled as TEXT column( 65,535 character limit).

    -

    Let me know if that makes sense, and if you have any questionssmile.png

    Or if i maybe misunderstood your query, please correct me and we will do our best to advise.

    Thank you

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables