Is there a limit to the number of characters in a text field? Coming from an Oracle database, text fields where stored as a VARCHAR type, meaning variable character lenght. This way the only data storage required was the actual size of the data in the field. While some of the records in my custom database may have only one or two sentences in a comments field, others may have many paragraphs… maybe even 12K characters or more.
Question: Can I input the text data, be it large or small, into a database field? or should I put the textual info into a hidden html page that is linked in the database?
Hi,
At the end of the article Field Type Support and Limitations in the Content Manager , a limit of 0.5 MB is stated (excluding images and documents) - that’s pretty big.
If you need further details or clarification, would recommend contacting the Wix support team , as they know best.
Good luck,
Yisrael
I am trying to save 72KB in a wixData text field and the update fails. It will work if I save a small amount of text but not the larger amount. The update object returned fails to show the text field. The documentation you reference above says I can store up to 500K.
Note that I can copy and paste the data into the text field using the database web interface, and can retrieve it in code. I can not however set the text field in code. This seems to clearly be a bug.
Note that I need this storage for B64 encoded images I am sending in emails.
A note on the recommendation to contact support above. I looked high an low for the proper category for coding issues and could not find it.