Emoticons not inserted in category descriptions

Phoca Download - download manager
Post Reply
User avatar
fabio42
Phoca Enthusiast
Phoca Enthusiast
Posts: 81
Joined: 09 Oct 2018, 16:39

Emoticons not inserted in category descriptions

Post 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
Top
User avatar
fabio42
Phoca Enthusiast
Phoca Enthusiast
Posts: 81
Joined: 09 Oct 2018, 16:39

Re: Emoticons not inserted in category descriptions

Post 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
Top
Post Reply

Return to “Phoca Download”