dannyd Posted September 3, 2024 Share Posted September 3, 2024 (edited) Hello We are on PS 1.7.7 Prestashop stores it's data encoded as utf8mb4. For instance: But all of the modules, that we installed, store their data as utf8mb3. For instance: 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 September 3, 2024 by dannyd (see edit history) Link to comment Share on other sites More sharing options...
Prestashop Addict Posted September 4, 2024 Share Posted September 4, 2024 (edited) Hi, utf8mb4 is used to support multi bytes characters like 🙈😂😱🍰☑🙏... If you want to support them, you should use this encoding. Edited September 4, 2024 by Prestashop Addict (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now