Page 1 of 1

Emoticons not inserted in category descriptions

Posted: 16 Apr 2020, 20:56
by fabio42
Hello !
I'm turning to you because I have issues inserting emoticons in category descriptions.
I recently opted for JCE Pro as an editor, which is fully compatible with all my website, meaning I have no problems adding emoticons to my articles. Yet, I cannot do so when it comes to typing a description of category :cry: . When I click on "save" in my editor, the smiley is tranformed into a "?", which is a problem. I contacted JCE developers and they told me that it was most probably due to the fact that my databse tables (the phocadownload ones ??) were not utf-8 (I quote : "the encoding and collation of the table must be UTF-8 Unicode") ... any idea of how I could check this ? change this ? have you ever had questions about this ? :idea:
Thanks for helping me !
Fabio

Re: Emoticons not inserted in category descriptions

Posted: 16 Apr 2020, 22:52
by fabio42
Well, by dint of fiddling here and there in my databse, I finally found the solution. And yes, that was related to utf8 ...
The tables in which Phocadownload (categories) stocks the data was utf_generic_ci and I had to convert it to utf8mb4_unicode_ci.
Now everything works fine ! Thanks for your eye ! Issue is solved ! Hope this might help people in the same case as I was !
Fabio