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.
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),
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.
Hi, Michael
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 questions
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 | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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