klikrzys Posted October 5, 2019 Share Posted October 5, 2019 Hello! I have a little problem with saving emojis on pages, they are always saved as '????'. I changed a database charset and collation to utf8_unicode_ci, but it didnt help. Link to comment Share on other sites More sharing options...
adrian Posted October 6, 2019 Share Posted October 6, 2019 You need utf8mb4 3 1 Link to comment Share on other sites More sharing options...
klikrzys Posted October 6, 2019 Author Share Posted October 6, 2019 Sorry i wanted to write that i changed it to utf8mb4_unicode_ci. Here is query that i used to do it: ALTER DATABASE processwire CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ALTER TABLE field_body CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci Still - I cant save my emojis. ? 1 1 Link to comment Share on other sites More sharing options...
adrian Posted October 6, 2019 Share Posted October 6, 2019 Have you set: $config->dbCharset = 'utf8mb4'; in config.php? 3 2 Link to comment Share on other sites More sharing options...
adrian Posted October 6, 2019 Share Posted October 6, 2019 Also make sure that the "data" field/column in the field_body table is set to utf8mb4 2 2 Link to comment Share on other sites More sharing options...
klikrzys Posted October 6, 2019 Author Share Posted October 6, 2019 Ohh it works now - Thank you very much and sorry for the problem. ? 1 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