Massimo Caliman
by Massimo Caliman
~1 min read

Categories

  • MySQL

Tags

  • code
  • database
  • en
  • mysql

Well, you probably have different collations in some MySQL views; try to force the collation like this:```sql
SET character_set_client = ‘utf8mb4’; SET character_set_connection = ‘utf8mb4’; SET collation_connection = ‘utf8mb4_unicode_ci’;

drop view if exists myviewwithproblem; create view myviewwithproblem as … ```

obviously force to UTF-8 if you want this collation.