Problems with the Windows version of XAMPP, questions, comments, and anything related.
by 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
by 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
-
Altrea
- AF Moderator
-
- Posts: 11933
- Joined: 17. August 2009 13:05
- XAMPP version: several
- Operating System: Windows 11 Pro x64
by 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
by 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
-
Altrea
- AF Moderator
-
- Posts: 11933
- 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: xamchqh and 260 guests