Jump to content

Edit History

dannyd

dannyd

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.

dannyd

dannyd

Hello

We are on PS 1.7.7

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

screen-20240903-195852.thumb.png.f4b9201a0e5698b3897acab1415f17e6.png


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

screen-20240903-195944.png.5e9315bc3a93c29401805e5e7afa389b.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.

×
×
  • Create New...