Database Collation when installing Opencart 3.x, 4.x

 

To avoid several problems the database collation for opencart should be as follows:

- for Opencart 4.0.1.1 and above it should be "utf8mb4_general_ci"

- for Opencart 1.5.51 (Opencart  2.x, Opencart 3.x) up to Opencart 4.0.1.0 the collation should be "utf8_general_ci"

- for Opencart 1.4.1 up to Opencart 1.5.4.1 the collation should be "utf8_bin"

- for Opencart <1.1.1 up to Opencart 1.4.0 the collation should be "utf8_unicode_ci"

If you are using the latest version of mysql always use "utf8mb4_general_ci".

Never use UTF8mb3*