Page 1 of 1
Problem with Emoji in product description
Posted: Sat Jul 22, 2023 6:39 pm
by zigi00x
Hello,
some emoji like for example
do not want to be displayed in the product description, 3x question marks will be displayed instead.
How to solve this problem?
Thank you.
Opencart 3.0.2.0
PHP version: 7.3.29
utf8_general_ci
Re: Problem with Emoji in product description
Posted: Sat Jul 22, 2023 7:31 pm
by JNeuhoff
Use images. or the awesome font's built-in icons?
Re: Problem with Emoji in product description
Posted: Sat Jul 22, 2023 7:32 pm
by ADD Creative
You would need to change the database adaptor to use the utf8mb4 charset and select a utf8mb4 collation in your tables.
Re: Problem with Emoji in product description
Posted: Sun Jul 23, 2023 1:32 am
by zigi00x
Hi,
Thanks for the reply, i switch database to utf8mb4 ] but problem still persist only some emojis appear and the others have 3x question marks viz screens.
Thanks for the help.
Re: Problem with Emoji in product description
Posted: Sun Jul 23, 2023 4:49 am
by ADD Creative
Did you make the change in system/library/db/mysqli.php?
Re: Problem with Emoji in product description
Posted: Sun Jul 23, 2023 5:10 pm
by zigi00x
ADD Creative wrote: ↑Sun Jul 23, 2023 4:49 am
Did you make the change in system/library/db/mysqli.php?
Hi yess viz scren.
Re: Problem with Emoji in product description
Posted: Sun Jul 23, 2023 8:18 pm
by ADD Creative
Not sure why some would work and others not. Unless the entered code were wrong or the font doesn't support them.
Re: Problem with Emoji in product description
Posted: Mon Jul 24, 2023 3:27 am
by zigi00x
Yes, some support it and some don't, I don't know where the problem is..
do not want to be displayed in the product description, 3x question marks will be displayed instead.