Comment to 'emojis not working - SOLVED'
Comment to emojis not working - SOLVED

  • 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.

    • See older replies...

    • 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.

      • 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