Discussions

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

Bookmark and Share Get thread feed

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

    • Posted by: Jordan Lim
    • Posted on: December 25 2001 22:41 EST
    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
    Reply to this

    Threaded Messages (1)

  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
    Reply to this Reply to original