Hey there! While this doesn't appear to be a cPanel issue, most discussion around this error involves users moving data from a previous version to MySQL 8. Is that the case here? If so, there are some additional details on how MySQL handles that here:
stackoverflow.com
but it would be best to restore the data to the same MySQL server type of possible.
Loopback 4 + MySQL: Character set 'utf32_bin' cannot be used in conjunction with 'binary' in call to regexp_like
I am using loopback 4 with mysql 8.0.22. When I want to execute the following: let orders = await this.orderRepository.find({ where: {events: {regexp: new RegExp(`.*"id":${event.id}.*...
stackoverflow.com
but it would be best to restore the data to the same MySQL server type of possible.
| Thread starter | Similar threads | Forum | Replies | Date |
|---|---|---|---|---|
| B | Mysql character set / collation problem with Cpanel | Databases | 0 | |
| T | default MySQL collation and character set / charset | Databases | 21 | |
| K | Adding a new character set in mysql | Databases | 1 | |
| D | MySQL character set. | Databases | 1 | |
| R | Default character set for new databases | Databases | 4 |