3 ms·
It seems insane that the top Google SERP result for "mysql utf8"[1] mentions this, but not in the top answer, rather in the top comment to the top answer -- whi
by thephyber 9y ago
It seems insane that the top Google SERP result for "mysql utf8"[1] mentions this, but not in the top answer, rather in the top comment to the top answer -- which describes why the top answer is wrong.
Because of the way MySQL rolled out `utf8` (a strict subset of UTF8) then `utf8mb4` (which is a full UTF8 implementation), the other top result[2] is similarly poisoned where the directions describe using `utf8` and have an addendum describing `utf8mb4` (which isn't hard to miss).
[1] https://stackoverflow.com/questions/202205/how-to-make-mysql-handle-utf-8-properly https://stackoverflow.com/questions/202205/how-to-make-mysql...
[2] https://www.toptal.com/php/a-utf-8-primer-for-php-and-mysql https://www.toptal.com/php/a-utf-8-primer-for-php-and-mysql