change field from varchar(55) to something greater

  • I would like to change the field “name” in the wp_terms database from a varchar(55) to something larger, like a varchar(200).

    I know how to do this through phpmyadmin, but i just wanted to post to the community first to see if anybody thinks this is a bad idea, and what gotcha i might run into changing the database schema. This is a change for a site set to go into production next week so I don’t want to do anything too risky.

    what problems might i run into… on upgrade, after making the change…. etc?

    my client is using the xlanguage plugin, so the name field sometimes has 3 values, seperated by a | … so varchar(55) is often inconvenient.

    thanks!

Viewing 1 replies (of 1 total)

  • Hey there,

    I did hit a problem doing this. I upped the varchar on the link_description from 256 to 1024 (so i could put in longer link descriptions).

    When I upgraded next (from 2.5 to 2.5.1) wordpress reset the scheme and bumped it back down to 256. That ended up truncating all of my descriptions, which I had to then re-import from my backup.

    While I could continue re-importing every time I upgrade, I don’t think it is sustainable… such as if there is a major release and they change the schema more significantly I won’t be able to squeeze in my descriptions. I think.

    Best,
    Jason

Viewing 1 replies (of 1 total)
  • The topic ‘change field from varchar(55) to something greater’ is closed to new replies.