Search and Replace in the Database (5 posts)

  1. noelgreen
    Posted 8 years ago #

    I want to extend the 55 character limit that is set in the database... but I don't know anything / enough about MySQL to get in there, find it, and change it.

    Is there a plug-in, or a way, to search and replace the "55" limit from within the WP admin?

    Or how's the best way to do this?

  2. whooami
    Posted 8 years ago #

    You want to extend the 55 char limit for what?

  3. noelgreen
    Posted 8 years ago #

    So that I can have things entered in that are longer than 55 characters. :)

    Basically it comes down to 55 characters is limiting... it's a fine limit for most people 99.999% of the time. But, in my case, I need to be able to have much longer sets of data be allowed.

  4. Aaron Harun
    Posted 8 years ago #

    The only field in the database that has a 55 char limit is the term name, so it is easy enough to manually change it in phpMyAdmin.

    Or you can run the following query in phpMyAdmin. (Change wp_ to whatever prefix you have set.)

    "ALTER TABLE wp_terms CHANGE name name VARCHAR( 255 ) NOT NULL"

    I don't know what result it would have, so I'm not going to suggest doing it though.

  5. noelgreen
    Posted 8 years ago #

    Thanks Aaron.
    I may try it... (will back up first of course).
    I'm still not sure this is what's causing my problem though...

    Thanks again!

Topic Closed

This topic has been closed to new replies.

About this Topic