UTF-8 encoding problem

This is a known problem with our hosting.

The key issue is that phpMyAdmin uses UTF-8 character encoding, but our PHP setup is not configured to use it by default. We could fix it, but doing so would break many sites in the process, which is why we can’t.

Just not using any non-ASCII characters is one way to go around it. But you could also set the connection charset in your own code to use utf8.

With PDO, you can specify the charset to use in the database connection string: PHP: PDO_MYSQL DSN - Manual

With MySQLi, you can set it with the mysqli_set_charset function: PHP: mysqli::set_charset - Manual

1 Like