emojis not working - SOLVED

Hi UNA team,

When I select an emoji in profile posts it only prints a ? after posting.
In main timeline if there are emojis in the post it is not posting at all.
I have froola and fontawesome installed.

  • 633
  • More
Replies (15)
    • Hi Cem!

      Were your modules upgraded to the latest versions? If yes, then remind me your actual operator access.

      • LeonidS 
        hi Leonid I see that everything is upgraded normally.

        I am sending you the login info from PM.

        • Hello Cem Bagdatli ,

          Problem may be in collation of the `content` field of  `bx_timeline_events` table. It should be utf8mb4_unicode_ci, otherwise smiles can not be saved.

          • Ok I am checking now thanks Alexey

            • yes I changed the collation it was utf_general_ci
              now everything seems alright in timeline
              thanks Alexey  thanks LeonidS 

              • and for other places like blogs profile timeline they are still converted to "?"
                shall I change all UNA tables to utf8mb4_unicode_ci or which ones ?
                Alexey  ?

                • Yes, all text fields must be utf8mb4_unicode_ci to make emoji to work properly. However this collation is set upon install, it's very curious how you've got different collation. How you performed the installation ? did you move site somewhere ? or any DB transfer ? 

                  • yes Alex T⚜️  at first we had problems with Turkish letters in some contents with tables having latin1_swedish_ci .

                    Thats why I changed all tables with suitable fields to utf8mb4_unicode_ci  or utf8_unicode_ci

                    I installed with normal methods at first.
                    Upgrades were also normal.

                    I moved the database and site many times till to this permanent place.
                    How can I distinguish the fields the tables which has text or is there a list of the tables with utf8mb4_unicode_ci so I can correct them all one by one.

                    • Yes the  replacement of the posted emojis with ? problem is also cured when the collation of the tables and colums is changed to utf8mb4_unicode_ci .
                      I only have a problem left now:
                      the emojis that we select in the popup menu is being in a different sytle
                      for instance 😀 this one is printed as a black and white icon.

                      very interesting even here the same thing happens in edit mode the icon is yellowish when posted it converts to black and white.
                      (May be about the settings of fontawesom? I couldnt find enough explanation about the usage of fontawesome module in site)

                      • I think it would be easier to export the whole database and then import again but with the proper collation and charset.
                        • Thank you Alex.
                          Ok I will check like this.
                          What do you recommend about the changing icons?

                          In chrome it shows B&W icons in the popup and posted is same.
                          In firefox it shows yellow icons posted is B&W.
                          In Android Firefox popup icons and posted ones are same yellow set.

                          • What do you recommend about the changing icons?

                            every OS renders emoji using own way, on some older versions it maybe that some emoji are even missing.

                            • Thank you Alex

                              • Alex T⚜️ Cem - Gents so is it all tables in the db to be set to utf8mb4_unicode_ci or utf8_unicode_ci? My understanding is that utf8mb4_unicode_ci is set at default install. I had moved my site a couple time and some tables (most are utf8_general_ci). Should I change encoding on the entire db to utf8mb4_unicode_ci? is that the default setting for UNA.

                                • Alex T⚜️ Cem - Gents so is it all tables in the db to be set to utf8mb4_unicode_ci or utf8_unicode_ci? My understanding is that utf8mb4_unicode_ci is set at default install. I had moved my site a couple time and some tables (most are utf8_general_ci). Should I change encoding on the entire db to utf8mb4_unicode_ci? is that the default setting for UNA.

                                  Yes, you need to make sure that all tables and all fields in all tables are set to the same collation - utf8mb4_unicode_ci 

                                  Login or Join to comment.