DEV Community

Discussion on: MySQL charset (255) unknown to the client in MySQL and AWS RDS

Collapse
darkain profile image
Vincent Milum Jr

I think this bug may lie somewhere else. utf8mb4 is compatible with the MySQLi implementation all the way back to the PHP 5.x days. It could be that PDO itself has bugs in it, which I wouldn't be surprised. PDO doesn't do as well with more enterprise style features in MySQL/MariaDB. For instance, there is a ton of high available features in the normal MySQLi driver missing from PDO that are exploited in PUDL for scale out solutions: github.com/darkain/pudl (and PUDL forces the connection to utf8mb4, which is why I know it works in 5.x code)