emoji icons

-- HikaShop version -- : 4.0.2
-- Joomla version -- : 3.9.2
-- PHP version -- : 7.2

i love to copy & paste icons from this website to some of my contents: emojipedia.org

now i wanted to add a emoji to a category description but that does not work. after i hit the button save i have only a "?" question mark instead the icon.
is hikashop ready to work with emojis?
i use the editor JCE...

Hi,

It is not a problem of HikaShop.
HikaShop loads and stores the data in UTF8. So it supports all the characters included in UTF8 including emojis.
However, if you want that the stored emoji code is displayed as what you see on that website, it requires that the font used to display that texts supports the emoji code. And that will be hard to find unless you use the same font they use on their website.
As you can see on that website, they load a bunch of fonts for the emojis :
monosnap.com/file/dg1pwdkSWF1OBKz91cKLDMMsixeV0r
So that would mean that you would need to modify your template to add emoji supporting fonts to it, but it also depends on the browser and OS of the user.
For example, here is a thread about emoji issues on Joomla (which isn't really a Joomla issue):
issues.joomla.org/tracker/joomla-cms/9956
I would rather recommend to use images instead of emoji codes. The images will display exactly the same, regardless of the browser, the OS or the fonts on your website.

please look in my screenshot:
that is weird, because the green arrow is copy paste from the website what i showed you. i use in the topbar a custom html module from joomla and the editor JCE.
it does work as you see.

and i wanted to use also a emoji in the hikashop category, where the "?" question mark is instead.

i do not understand why it is going for one module and not for your cat desc's ...

Hi,

That's probably because it's not the same font used on both texts.

no, i use on both text's (joomla custom module and hikashop) my base website font: Tahoma
That's what does confuse me about this icons and hikashop.

Hi,

So please set the editor setting of the HikaShop configuration to "none" so that you don't have a text editor for the description. Then, set the emoji in the description again, save it again and see if that helps.
If it does, then the issue comes from the text editor.
I personnally tested the same emoji in a category description with the default editor of Joomla and the default template of Joomla and it works just fine:
monosnap.com/file/aAbTdxs7aroYGqjzhhPeC2IphNwCxk
monosnap.com/file/k2RlfrD1W3FuyYLZ2tRd1LEZqjJTY4

yes it does work with the NONE editor plugin in hikashop.

Hi,

Well, this looks like an issue with the JCE editor then.
Can you also try with the tinyMCE editor ?

the tinyMCE editor does also work, look like indeed as a problem from JCE editor.

Hi,

I would recommend trying the same thing with a joomla article and then report the problem to the JCE support so that they can look into it.

please view the message from JCE Developer:
www.joomlacontenteditor.net/support/foru...cription#reply-98035

Well, the support from JCE is saying that when he set the editor to "no editor" and test he still has the issue, while you said you hadn't the issue.
So can you please confirm whether or not you have the issue without the JCE editor ?
Could you also provide a backend access and instructions to reproduce the issue along with a link to this thread via our contact form so that we can look into it since we don't have the problem on our end ?
www.hikashop.com/support/contact-us.html

Hi,

From what I understand, the issue is a collation issue in your database.
emojipedia.org/balloon/ requires utf8mb4 encoding collation while HikaShop uses the utf8 encoding collation which only supports 3 bytes UTF8 code and emojipedia.org/balloon/ is a 4 bytes UTF8 code.
So you need to change the collation of the hikashop_category table via your phpmyadmin and then it will work fine in the category description.
There is actually the same issue with the kunena (forum) table on our website as if you try to add the emojipedia.org/balloon/ emoji in your message, it will be converted to ? as the character is not supported by the collation.

i guess sooner or later you'll be switching to utf8mb4 encoding anyway or? i see more and more joomla components using this encoding.

Hello,

We won't change the encoding during updates but new installation would have the utf8mb4 encoding.
Afterwards, you're free to change the encoding manually in your side.

Regards,

ok, that makes sense.

has anyone experience in changing the database collation from utf8 to utf8mb4?
or have a tested SQL query to change the encoding on existing installations to switch to utf8mb4?

Update: is the option in "Admin Tools" from Akeebabackup to change database collation a saver option?
www.akeebabackup.com/documentation/admin.../database-tools.html

Hi,

You can do that in phpmyadmin quite easily:
mediatemple.net/community/products/dv/20...er-set-and-collation
There is no problem doing it.