Skip to content

Instantly share code, notes, and snippets.

View podarcis's full-sized avatar

Dominik podarcis

  • Arvato Systems GmbH
  • Germaringen (Germany)
  • 10:32 (UTC +01:00)
View GitHub Profile
@podarcis
podarcis / convert-utf8-to-utf8mb4.sh
Last active July 17, 2020 06:48
A shell script that can assist in converting a Pimcore 4 database with utf8 encoding to utf8mb4. See https://github.com/pimcore/pimcore/issues/6698
#!/usr/bin/env bash
#
# Tool for converting (Pimcore) utf8 database to utf8mb4
# Author: dominik@weblizards.de
#
# Versions:
# 1 - Inital version
# 2 - Don't alter (EcommerceFramework) table default with charset=utf8 and collation=utf8_bin
#
# Credits to write up: https://mathiasbynens.be/notes/mysql-utf8mb4