Apache Friends Support Forum

I've installed the latest version of xampp "xampp-win32-5.6.8-0-VC11-installer" and found that the php was deprecated so I opted to use xampp 1.7.0 that I used before to setup a project but the mysql throws an error:

Error

SQL query: Edit

SET NAMES 'utf8mb4' COLLATE 'utf8mb4_unicode_ci';

MySQL said: Documentation
#1115 - Unknown character set: 'utf8mb4'

I assume the Mysql is not the same as the one coming with 1.7 but for 5.6 how can I fix this issue?

MySQL supports utf8mb4 since MySQL v5.5.3
XAMPP 1.7.0 uses a much older MySQL version.

So replace all utf8mb4 with utf8.

Quick question how do you do that?

That depends on your applications. At some point it is sending this SET NAMES command. Maybe it is configurable, maybe it can only be solved by using an older version of that application.