search

WalkingPizza / strapi-plugin-placeholder

Serve placeholders with your Strapi images
MIT License
29 stars 20 forks source link

MySQL Collation issue #19

Closed aKaradzhov97 closed 6 months ago

aKaradzhov97 commented 6 months ago

For future references: For those of you running into collation issues when executing the MySQL migration script, here's what I had to do:

  1. Replace andWhereLike with andWhereILike in the migration script.
  2. Manually add the "placeholder" column to your database and make sure it can be long enough. (Don't limit it to 255 chars or so). Ideally use TEXT instead of VARCHAR(255). Enjoy! 💯