I am using a "manual entry" table. I have a column set up as a String. It errors if I try to enter more that 256 characters in that field.
My goal is to have a field with HTML-formatted text that is longer than 256 characters. Is that possible in any scenario? I can use an Excel file or MySQL db if that helps.
I figured it out myself. Once you have a column, you are unable to change it from a "one line string" to a "multi-line string". But you CAN create a new column as "multi-line string".
Basically, this happens because when you create a column in wpDataTables as "one line string"; at the same time, a column gets created in the database, as data type of VARCHAR (single-line string) , that has a default character length of 255 characters.
The best solution you can do here is to firstly delete this column that was made as "one line string" ; then create a new column, and set data type to "Multi-line string". That will save the column as TEXT type (in the database) instead of VARCHAR and you'll be able to enter up to 65.000 characters in each cell.
- If anything was not clear, or you need more details, please contact us further.
I am using a "manual entry" table. I have a column set up as a String. It errors if I try to enter more that 256 characters in that field.
My goal is to have a field with HTML-formatted text that is longer than 256 characters. Is that possible in any scenario? I can use an Excel file or MySQL db if that helps.
I figured it out myself. Once you have a column, you are unable to change it from a "one line string" to a "multi-line string". But you CAN create a new column as "multi-line string".
Hi, Kyra
Thank you for your purchase.
Basically, this happens because when you create a column in wpDataTables as "one line string"; at the same time, a column gets created in the database, as data type of VARCHAR (single-line string) , that has a default character length of 255 characters.
The best solution you can do here is to firstly delete this column that was made as "one line string" ; then create a new column, and set data type to "Multi-line string". That will save the column as TEXT type (in the database) instead of VARCHAR and you'll be able to enter up to 65.000 characters in each cell.
- If anything was not clear, or you need more details, please contact us further.
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
Hello, Kyra.
I apologise for not realising that you already sent a response,
but I am glad to see you have resolved this.
If anything else happens that we could assist with, don't hesitate to create a new ticket, and we will be here.
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