Xampp Mysql error SET NAMES 'utf8mb4' COLLATE 'utf8mb4_unico

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Xampp Mysql error SET NAMES 'utf8mb4' COLLATE 'utf8mb4_unico

Postby rensonmuthomi » 27. April 2015 09:55

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?
rensonmuthomi
 
Posts: 2
Joined: 27. April 2015 09:48
Operating System: Windows 8

Re: Xampp Mysql error SET NAMES 'utf8mb4' COLLATE 'utf8mb4_u

Postby Altrea » 27. April 2015 10:00

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

So replace all utf8mb4 with utf8.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Xampp Mysql error SET NAMES 'utf8mb4' COLLATE 'utf8mb4_u

Postby rensonmuthomi » 27. April 2015 15:31

Quick question how do you do that?
rensonmuthomi
 
Posts: 2
Joined: 27. April 2015 09:48
Operating System: Windows 8

Re: Xampp Mysql error SET NAMES 'utf8mb4' COLLATE 'utf8mb4_u

Postby Altrea » 27. April 2015 16:45

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: Altrea and 127 guests