SQL error on query Index column size too large. The maximum column size is 767 bytes

Question

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

prestashop 1.7

> DEFAULT CHARSET=utf8mb4 COLLATION

with

> DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

then klick the restart button and the install works..

but not sure if this has any long term impact on the shop