Web tier: servlets, JSP, Web frameworks: Limit of varchar when using MySQL??
- Posted by: Jordan Lim
- Posted on: December 25 2001 22:41 EST
How many characters are allowed when using MySQL. I've read that when using "varchar" or "char" in MySQL, the limit is 255. Is there any way that I can increase the number of characters available??
you can use either text or blob if you need to store large amounts of text. see
a good way to figure out this kind of problems is to check the manufacturers homepage, in this case www.mysql.com where you can find any information you need.
but I suggest you use "text" -datatype in this case.