When you are running a multiple PHP applications around the same Database you might get this error which results in not rendering the block. Here is a quick fix for it.
Unknown Collation error usually arrises when you try to move a DB from a higher mysql version e.x, 8.0 to a lower mysql version e.x, 5.7
Subscribe to mysql
Upgrading to MySQL 8.0 from MySQL 5.7 offers several benefits such as improved performance, better security, and better support for JSON and spatial data. The upgrade process is straightforward, and you can follow the steps outlined in this blog