MySQL: Text field can only store 65535 characters
Question by Compi | Last update on 2021-02-22 | Created on 2019-06-13
I am using a field of data type "TEXT" in my MySQL database to save texts. Unfortunately, I realized now that a field of type TEXT can only hold 65,535 characters. All remaining characters are simply cut off.
What can I do to save longer texts with MySQL? The type VARCHAR also seems to be not suitable, here the length seems to be limited to only 255 characters. Does somebody has any idea?
Related Topics
How to Replace multiple Texts at the same Time
Tutorial | 0 Comments
Textarea Maxlength: Limit Maximum Number of Characters in Textarea
Tutorial | 3 Comments
PHP: Check Strings with Ctype-Functions for Character Classes
Article | 0 Comments
Send Form Input as an Array to PHP Script
Tip | 0 Comments
PHP: Remove arbitrary Characters at the Beginning and the End of a String
Tutorial | 0 Comments
Lord's Prayer in 20 other Languages
Info | 0 Comments
Important Note
Please note: The contributions published on askingbox.com are contributions of users and should not substitute professional advice. They are not verified by independents and do not necessarily reflect the opinion of askingbox.com. Learn more.
Participate
Ask your own question or write your own article on askingbox.com. That’s how it’s done.
There are several TEXT data types in MySQL that can store different text lengths.
Here is a small overview:
If the 65,535 characters of the TEXT type are not enough for you, you should use MEDIUMTEXT or LONGTEXT instead.
Last update on 2021-02-22 | Created on 2019-06-13