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

    πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
    • 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.

      πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
      • 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.


        πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0
        • 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Β 

          πŸ’“0 πŸ˜†0 😲0 πŸ˜₯0 😠0 0

        UNA - Network Infrastructure for Communities

        Close