dodo Moderator Từ Lithuania Thành viên kể từ thg 3 2016 dodo 2 thg 12 2020 15:41 How to add emoji compatibility for this addon? If someone adds emoji, it is shown as ???? in the review, but it is shown as emoji in the review confirmation email.
tonny Curtain Guru Từ Netherlands Thành viên kể từ thg 12 2016 tonny 2 thg 12 2020 18:06 Wich version are you running?
dodo Moderator Từ Lithuania Thành viên kể từ thg 3 2016 dodo 2 thg 12 2020 18:37 Last. Ok it seems there is one emoji existing in reviews. But not all.
tonny Curtain Guru Từ Netherlands Thành viên kể từ thg 12 2016 tonny 2 thg 12 2020 19:18 I see that this add-on needs an update. So better to wait until Tim has updated this. He will see this. Reviews Updated for Litecart 2.2.4 Compatible Versions: 2.2.4
tim Founder Từ Sweden Thành viên kể từ thg 5 2013 tim 2 thg 12 2020 23:10 To allow emojis to be stored in database go to Admin -> Languages -> Storage Encoding and convert all tables to a utf8mb4 collation.
user3196563 Developer Từ Slovak Republic Thành viên kể từ thg 5 2025 user3196563 7 thg 5 2025 08:42 Version 2.6.2. In "Admin -> Languages -> Storage Encoding" I changed the encoding to "utf8mb4_unicode_ci, InnoDB" - it did not help. Then in includes/config.inc.php I changed the line: define('DB_CONNECTION_CHARSET', 'utf8mb4'); - it also did not help. As a result, in includes/app_header.inc.php at the very bottom I added the line: database::query("SET NAMES 'utf8mb4'"); And it worked for me! Emoji started to display correctly.
