utf8mb4 support (column length)

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Ron Rennick

    (@wpmuguru)

    10 years ago

    Thanks. I’ll try to look at that over the next couple weeks.

    OzTheGreat

    (@ozthegreat)

    10 years ago

    Yeah just run into this as well. Best solution I’ve found so far is to just limit the index length on the domain column:

    CREATE TABLE IF NOT EXISTS wpa_domain_mapping (
    id bigint(20) NOT NULL auto_increment,
    blog_id bigint(20) NOT NULL,
    domain varchar(255) NOT NULL,
    active tinyint(4) default ‘1’,
    PRIMARY KEY (id),
    KEY blog_id (blog_id,domain(229),active)
    );

    Reducing the id and blog_id columns to int(10) will enable you to bump that number up a bit more. I doubt anyone would be hitting the int() limit

    Plugin Author Ron Rennick

    (@wpmuguru)

    10 years ago

    Thanks for the additional info 🙂 Since domain mapping is now effectively a legacy application I will probably limit the field length. Anyone who already has had it installed ast some point won’t be affected by the change. New installs should just be using the arbitrary URL feature built into WP.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘utf8mb4 support (column length)’ is closed to new replies.