2 columns of Wishlist plugin do not allow collation

  • Hi,
    I am changing my MySQL WP database collation from utf8_general_ci to utf8mb4 because it was mixed setup by default, better to have only 1 collation, and I selected the newer one because it allows e.g. emoticons in product descriptions.

    However, 2 columns in YITH Woocommerce Wishlist plugin did not allow the change and complained about that key length will be too long. These were
    table: wp_yith_wcwl_lists
    columns: wishlist_token and wishlist_slug

    Do you have some tips how to allow these to use the same collation as everything else? Specifically I am using utf8mb4_swedish_ci to allow some special letters.

Viewing 1 replies (of 1 total)
  • Plugin Author YITHEMES

    (@yithemes)

    Hi there

    I just tried to change collation on my local installation, and I was able to set up utf8mb4 for my columns without any problem

    Regarding key length constraint, I feel like this may be related to number of characters included in the column
    You may want to remove them and apply them again after you changed collation
    If this is not possible due to data length, you may also think of reducing character count for each of this columns

    Wishlist token is by defualt 12 character long, and column is bigger only to accomodate any possible custom token
    Regarding wishlist slug, this actually depends on title, and isn’t limited via code (an error that we will fix in next plugin version)
    Anyway, index on this specific column is less required, since queries over it are quite rare

Viewing 1 replies (of 1 total)
  • The topic ‘2 columns of Wishlist plugin do not allow collation’ is closed to new replies.