CODE EXAMPLE FOR SQL

Erreur SQL sur la requête Index column size too large. The maximum column size is 767 bytes.

/* PRESTASHOP */
/* you could edit the file install/data/db_structure.sql and replace every occurance of */

DEFAULT CHARSET=utf8mb4 COLLATION

/* with */

DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

/* then click the restart button and the install works..
but not sure if this has any long term impact on the shop */