Jump to content

Changing data encoding in the MariaDB SQL server from utf8mb3 to utf8mb4


Recommended Posts

Hello

We are on PS 1.7.7

Prestashop stores it's data encoded as utf8mb4.
For instance:

screen-20240903-195852.thumb.png.883a5d3e2d1e1e193feeb1c07a31156c.png


But all of the modules, that we installed, store their data as utf8mb3.
For instance:

screen-20240903-195944.png.da28704f315713a241fa2d599b83fb16.png

 

Our MariaDB SQL server is currently configured with

"character-set-server = utf8"

which defaults to utf8mb3.
We need to change that setting to utf8mb4.

Does anyone have any experience with character encoding?
What would be the consequences of such a change for Prestashop operations and it's data stored in the database?
Thank you for any suggestions.

Edited by dannyd (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...