Limit of varchar when using MySQL??

Discussions

Web tier: servlets, JSP, Web frameworks: Limit of varchar when using MySQL??

  1. Limit of varchar when using MySQL?? (1 messages)

    Hi,

    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??

    LeO
  2. Limit of varchar when using MySQL??[ Go to top ]

    you can use either text or blob if you need to store large amounts of text. see

    http://www.devshed.com/Server_Side/MySQL/Intro/page3.html

    for details.

    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.


    Regards,
    Kari