# Emojis not working **URL:** \ **Category:** 💬 Talk (spreed)\ **Created:** [November 26, 2019, 8:47am UTC](https://help.nextcloud.com/t/emojis-not-working/65004 "2019-11-26T08:47:35Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Nobody](https://help.nextcloud.com/letter_avatar/nobody/32/5_5575768a8748004e209b776fc1b2916d.png) [@Nobody](https://help.nextcloud.com/u/Nobody)\ **Post date:** [November 26, 2019, 8:47am UTC](https://help.nextcloud.com/t/emojis-not-working/65004/1 "2019-11-26T08:47:35Z")
Hi, I get “???” when I try so send emojis on my android app through my NC 17. I did everythin written here: [https://docs.nextcloud.com/server/stable/admin\_manual/configuration\_database/mysql\_4byte\_support.html](https://docs.nextcloud.com/server/stable/admin_manual/configuration_database/mysql_4byte_support.html) ``` MariaDB [nextcloud]> show variables like 'innodb_file_format'; ``` ±-------------------±----------+ | Variable\_name | Value | ±-------------------±----------+ | innodb\_file\_format | Barracuda | ±-------------------±----------+ 1 row in set (0.01 sec) MariaDB [nextcloud]\> show variables like ‘innodb\_file\_per\_table’; ±----------------------±------+ | Variable\_name | Value | ±----------------------±------+ | innodb\_file\_per\_table | ON | ±----------------------±------+ 1 row in set (0.01 sec) MariaDB [nextcloud]\> show variables like ‘innodb\_large\_prefix’; ±--------------------±------+ | Variable\_name | Value | ±--------------------±------+ | innodb\_large\_prefix | ON | ±--------------------±------+ 1 row in set (0.00 sec) Server version: 10.1.41-MariaDB-0+deb9u1 Debian 9.9 OS: Unknown 9.11 stretch Kernel: x86\_64 Linux 5.0.21-2-pve and > MariaDB [(none)]\> SELECT NAME, SPACE, FILE\_FORMAT FROM INFORMATION\_SCHEMA.INNODB\_SYS\_TABLES WHERE NAME like “nextcloud%”; > ±----------------------------------------------------±------±------------+ > | NAME | SPACE | FILE\_FORMAT | > ±----------------------------------------------------±------±------------+ > | nextcloud/oc\_accounts | 42885 | Barracuda | > | nextcloud/oc\_activity | 42886 | Barracuda | > | nextcloud/oc\_activity\_mq | 42887 | Barracuda | > | nextcloud/oc\_addressbookchanges | 42888 | Barracuda | > | nextcloud/oc\_addressbooks | 42889 | Barracuda | > | nextcloud/oc\_appconfig | 42890 | Barracuda | > | nextcloud/oc\_audioplayer\_albums | 42891 | Barracuda | > | nextcloud/oc\_audioplayer\_artists | 42892 | Barracuda | > | nextcloud/oc\_audioplayer\_genre | 42893 | Barracuda | > | nextcloud/oc\_audioplayer\_playlist\_tracks | 42894 | Barracuda | > | nextcloud/oc\_audioplayer\_playlists | 42895 | Barracuda | > | nextcloud/oc\_audioplayer\_stats | 42896 | Barracuda | > | nextcloud/oc\_audioplayer\_streams | 42897 | Barracuda | > | nextcloud/oc\_audioplayer\_tracks | 42898 | Barracuda | > | nextcloud/oc\_authtoken | 42899 | Barracuda | > | nextcloud/oc\_bookmarks | 42900 | Barracuda | > | nextcloud/oc\_bookmarks\_folders | 42901 | Barracuda | > | nextcloud/oc\_bookmarks\_folders\_bookmarks | 42902 | Barracuda | > | nextcloud/oc\_bookmarks\_tags | 42903 | Barracuda | > | nextcloud/oc\_bruteforce\_attempts | 42904 | Barracuda | > | nextcloud/oc\_calendar\_invitations | 42905 | Barracuda | > | nextcloud/oc\_calendar\_resources | 42906 | Barracuda | > | nextcloud/oc\_calendar\_rooms | 42907 | Barracuda | > | nextcloud/oc\_calendarchanges | 42908 | Barracuda | > | nextcloud/oc\_calendarobjects | 42909 | Barracuda | > | nextcloud/oc\_calendarobjects\_props | 42910 | Barracuda | > | nextcloud/oc\_calendars | 42911 | Barracuda | > | nextcloud/oc\_calendarsubscriptions | 42912 | Barracuda | > | nextcloud/oc\_cards | 42913 | Barracuda | > | nextcloud/oc\_cards\_properties | 42914 | Barracuda | > | nextcloud/oc\_carnet\_metadata | 42915 | Barracuda | > | nextcloud/oc\_circles\_circles | 42916 | Barracuda | > | nextcloud/oc\_circles\_clouds | 42917 | Barracuda | > | nextcloud/oc\_circles\_groups | 42918 | Barracuda | > | nextcloud/oc\_circles\_links | 42919 | Barracuda | > | nextcloud/oc\_circles\_members | 42920 | Barracuda | > | nextcloud/oc\_circles\_shares | 42921 | Barracuda | > | nextcloud/oc\_cms\_pico\_websites | 42922 | Barracuda | > | nextcloud/oc\_collres\_accesscache | 42923 | Barracuda | > | nextcloud/oc\_collres\_collections | 42924 | Barracuda | > | nextcloud/oc\_collres\_resources | 42925 | Barracuda | > | nextcloud/oc\_comments | 42926 | Barracuda | > | nextcloud/oc\_comments\_read\_markers | 42927 | Barracuda | > | nextcloud/oc\_cookbook\_keywords | 42928 | Barracuda | > | nextcloud/oc\_cookbook\_names | 42929 | Barracuda | > | nextcloud/oc\_cospend\_bill\_owers | 42930 | Barracuda | > | nextcloud/oc\_cospend\_bills | 42931 | Barracuda | > | nextcloud/oc\_cospend\_ext\_projects | 42932 | Barracuda | > | nextcloud/oc\_cospend\_members | 42933 | Barracuda | > | nextcloud/oc\_cospend\_projects | 42934 | Barracuda | > | nextcloud/oc\_cospend\_shares | 42935 | Barracuda | > | nextcloud/oc\_credentials | 42936 | Barracuda | > | nextcloud/oc\_dashboard\_events | 42937 | Barracuda | > | nextcloud/oc\_dashboard\_settings | 42938 | Barracuda | > | nextcloud/oc\_dav\_shares | 42939 | Barracuda | > | nextcloud/oc\_deck\_assigned\_labels | 42940 | Barracuda | > | nextcloud/oc\_deck\_assigned\_users | 42941 | Barracuda | > | nextcloud/oc\_deck\_attachment | 42942 | Barracuda | > | nextcloud/oc\_deck\_board\_acl | 42943 | Barracuda | > | nextcloud/oc\_deck\_boards | 42944 | Barracuda | > | nextcloud/oc\_deck\_cards | 42945 | Barracuda | > | nextcloud/oc\_deck\_labels | 42946 | Barracuda | > | nextcloud/oc\_deck\_stacks | 42947 | Barracuda | > | nextcloud/oc\_directlink | 42948 | Barracuda | > | nextcloud/oc\_e2e\_encryption\_lock | 42949 | Barracuda | > | nextcloud/oc\_federated\_reshares | 42950 | Barracuda | > | nextcloud/oc\_file\_locks | 42951 | Barracuda | > | nextcloud/oc\_filecache | 42952 | Barracuda | > | nextcloud/oc\_files\_antivirus | 42953 | Barracuda | > | nextcloud/oc\_files\_avir\_status | 42954 | Barracuda | > | nextcloud/oc\_files\_trash | 42955 | Barracuda | > | nextcloud/oc\_flow\_checks | 42956 | Barracuda | > | nextcloud/oc\_flow\_operations | 42957 | Barracuda | > | nextcloud/oc\_fulltextsearch\_indexes | 42958 | Barracuda | > | nextcloud/oc\_fulltextsearch\_ticks | 42959 | Barracuda | > | nextcloud/oc\_gpxedit\_options | 42960 | Barracuda | > | nextcloud/oc\_gpxedit\_tile\_servers | 42961 | Barracuda | > | nextcloud/oc\_gpxmotion\_options | 42962 | Barracuda | > | nextcloud/oc\_gpxmotion\_tile\_server | 42963 | Barracuda | > | nextcloud/oc\_gpxpod\_directories | 42964 | Barracuda | > | nextcloud/oc\_gpxpod\_options\_values | 42965 | Barracuda | > | nextcloud/oc\_gpxpod\_pictures | 42966 | Barracuda | > | nextcloud/oc\_gpxpod\_tile\_servers | 42967 | Barracuda | > | nextcloud/oc\_gpxpod\_tracks | 42968 | Barracuda | > | nextcloud/oc\_group\_admin | 42969 | Barracuda | > | nextcloud/oc\_group\_folders | 42970 | Barracuda | > | nextcloud/oc\_group\_folders\_acl | 42971 | Barracuda | > | nextcloud/oc\_group\_folders\_groups | 42972 | Barracuda | > | nextcloud/oc\_group\_folders\_manage | 42973 | Barracuda | > | nextcloud/oc\_group\_folders\_trash | 42974 | Barracuda | > | nextcloud/oc\_group\_user | 42975 | Barracuda | > | nextcloud/oc\_groups | 42976 | Barracuda | > | nextcloud/oc\_jobs | 42977 | Barracuda | > | nextcloud/oc\_login\_flow\_v2 | 42978 | Barracuda | > | nextcloud/oc\_mail\_accounts | 42979 | Barracuda | > | nextcloud/oc\_mail\_aliases | 42980 | Barracuda | > | nextcloud/oc\_mail\_attachments | 42981 | Barracuda | > | nextcloud/oc\_mail\_coll\_addresses | 42982 | Barracuda | > | nextcloud/oc\_mail\_mailboxes | 42983 | Barracuda | > | nextcloud/oc\_maps\_address\_geo | 42984 | Barracuda | > | nextcloud/oc\_maps\_apikeys | 42985 | Barracuda | > | nextcloud/oc\_maps\_device\_points | 42986 | Barracuda | > | nextcloud/oc\_maps\_devices | 42987 | Barracuda | > | nextcloud/oc\_maps\_favorites | 42988 | Barracuda | > | nextcloud/oc\_maps\_photos | 42989 | Barracuda | > | nextcloud/oc\_maps\_tracks | 42990 | Barracuda | > | nextcloud/oc\_migrations | 42991 | Barracuda | > | nextcloud/oc\_mimetypes | 42992 | Barracuda | > | nextcloud/oc\_mindmaps | 42993 | Barracuda | > | nextcloud/oc\_mindmaps\_acl | 42994 | Barracuda | > | nextcloud/oc\_mindmaps\_nodes | 42995 | Barracuda | > | nextcloud/oc\_mounts | 42996 | Barracuda | > | nextcloud/oc\_music\_albums | 42997 | Barracuda | > | nextcloud/oc\_music\_ampache\_sessions | 42998 | Barracuda | > | nextcloud/oc\_music\_ampache\_users | 42999 | Barracuda | > | nextcloud/oc\_music\_artists | 43000 | Barracuda | > | nextcloud/oc\_music\_cache | 43001 | Barracuda | > | nextcloud/oc\_music\_playlists | 43002 | Barracuda | > | nextcloud/oc\_music\_tracks | 43003 | Barracuda | > | nextcloud/oc\_notes\_meta | 43004 | Barracuda | > | nextcloud/oc\_notifications | 43005 | Barracuda | > | nextcloud/oc\_notifications\_pushtokens | 43006 | Barracuda | > | nextcloud/oc\_oauth2\_access\_tokens | 43007 | Barracuda | > | nextcloud/oc\_oauth2\_clients | 43008 | Barracuda | > | nextcloud/oc\_ocdownloader\_adminsettings | 43009 | Barracuda | > | nextcloud/oc\_ocdownloader\_personalsettings | 43010 | Barracuda | > | nextcloud/oc\_ocdownloader\_queue | 43011 | Barracuda | > | nextcloud/oc\_ocsms\_config | 43012 | Barracuda | > | nextcloud/oc\_ocsms\_conversation\_read\_states | 43013 | Barracuda | > | nextcloud/oc\_ocsms\_sendmessage\_queue | 43014 | Barracuda | > | nextcloud/oc\_ocsms\_smsdatas | 43015 | Barracuda | > | nextcloud/oc\_ocsms\_user\_datas | 43016 | Barracuda | > | nextcloud/oc\_passman\_credentials | 43017 | Barracuda | > | nextcloud/oc\_passman\_delete\_vault\_request | 43018 | Barracuda | > | nextcloud/oc\_passman\_files | 43019 | Barracuda | > | nextcloud/oc\_passman\_revisions | 43020 | Barracuda | > | nextcloud/oc\_passman\_share\_request | 43021 | Barracuda | > | nextcloud/oc\_passman\_sharing\_acl | 43022 | Barracuda | > | nextcloud/oc\_passman\_vaults | 43023 | Barracuda | > | nextcloud/oc\_passwords\_entity\_challenge | 43024 | Barracuda | > | nextcloud/oc\_passwords\_entity\_folder | 43025 | Barracuda | > | nextcloud/oc\_passwords\_entity\_folder\_revision | 43026 | Barracuda | > | nextcloud/oc\_passwords\_entity\_keychain | 43027 | Barracuda | > | nextcloud/oc\_passwords\_entity\_password | 43028 | Barracuda | > | nextcloud/oc\_passwords\_entity\_password\_revision | 43029 | Barracuda | > | nextcloud/oc\_passwords\_entity\_session | 43030 | Barracuda | > | nextcloud/oc\_passwords\_entity\_share | 43031 | Barracuda | > | nextcloud/oc\_passwords\_entity\_tag | 43032 | Barracuda | > | nextcloud/oc\_passwords\_entity\_tag\_revision | 43033 | Barracuda | > | nextcloud/oc\_passwords\_relation\_password\_tag | 43034 | Barracuda | > | nextcloud/oc\_phonetrack\_devices | 43035 | Barracuda | > | nextcloud/oc\_phonetrack\_filtersb | 43036 | Barracuda | > | nextcloud/oc\_phonetrack\_geofences | 43037 | Barracuda | > | nextcloud/oc\_phonetrack\_options | 43038 | Barracuda | > | nextcloud/oc\_phonetrack\_points | 43039 | Barracuda | > | nextcloud/oc\_phonetrack\_proxims | 43040 | Barracuda | > | nextcloud/oc\_phonetrack\_pubshares | 43041 | Barracuda | > | nextcloud/oc\_phonetrack\_sessions | 43042 | Barracuda | > | nextcloud/oc\_phonetrack\_shares | 43043 | Barracuda | > | nextcloud/oc\_phonetrack\_tileserver | 43044 | Barracuda | > | nextcloud/oc\_polls\_comments | 43045 | Barracuda | > | nextcloud/oc\_polls\_events | 43046 | Barracuda | > | nextcloud/oc\_polls\_notif | 43047 | Barracuda | > | nextcloud/oc\_polls\_options | 43048 | Barracuda | > | nextcloud/oc\_polls\_votes | 43049 | Barracuda | > | nextcloud/oc\_preferences | 43050 | Barracuda | > | nextcloud/oc\_preview\_generation | 43051 | Barracuda | > | nextcloud/oc\_privacy\_admins | 43052 | Barracuda | > | nextcloud/oc\_properties | 43053 | Barracuda | > | nextcloud/oc\_quicknotes\_colors | 43054 | Barracuda | > | nextcloud/oc\_quicknotes\_notes | 43055 | Barracuda | > | nextcloud/oc\_quicknotes\_shares | 43056 | Barracuda | > | nextcloud/oc\_quicknotes\_tasks | 43057 | Barracuda | > | nextcloud/oc\_radio\_stations | 43058 | Barracuda | > | nextcloud/oc\_ransomware\_detection | 43059 | Barracuda | > | nextcloud/oc\_richdocuments\_assets | 43060 | Barracuda | > | nextcloud/oc\_richdocuments\_direct | 43061 | Barracuda | > | nextcloud/oc\_richdocuments\_member | 43062 | Barracuda | > | nextcloud/oc\_richdocuments\_wopi | 43063 | Barracuda | > | nextcloud/oc\_schedulingobjects | 43064 | Barracuda | > | nextcloud/oc\_sensorlogger\_data\_types | 43065 | Barracuda | > | nextcloud/oc\_sensorlogger\_device\_data\_types | 43066 | Barracuda | > | nextcloud/oc\_sensorlogger\_device\_groups | 43067 | Barracuda | > | nextcloud/oc\_sensorlogger\_device\_types | 43068 | Barracuda | > | nextcloud/oc\_sensorlogger\_devices | 43069 | Barracuda | > | nextcloud/oc\_sensorlogger\_logs | 43070 | Barracuda | > | nextcloud/oc\_share | 43071 | Barracuda | > | nextcloud/oc\_share\_external | 43072 | Barracuda | > | nextcloud/oc\_storages | 43073 | Barracuda | > | nextcloud/oc\_systemtag | 43074 | Barracuda | > | nextcloud/oc\_systemtag\_group | 43075 | Barracuda | > | nextcloud/oc\_systemtag\_object\_mapping | 43076 | Barracuda | > | nextcloud/oc\_talk\_commands | 43077 | Barracuda | > | nextcloud/oc\_talk\_guests | 43078 | Barracuda | > | nextcloud/oc\_talk\_participants | 43079 | Barracuda | > | nextcloud/oc\_talk\_rooms | 43080 | Barracuda | > | nextcloud/oc\_talk\_signaling | 43081 | Barracuda | > | nextcloud/oc\_text\_documents | 43082 | Barracuda | > | nextcloud/oc\_text\_sessions | 43083 | Barracuda | > | nextcloud/oc\_text\_steps | 43084 | Barracuda | > | nextcloud/oc\_timetracker\_client | 43085 | Barracuda | > | nextcloud/oc\_timetracker\_locked\_project\_allowed\_tag | 43086 | Barracuda | > | nextcloud/oc\_timetracker\_project | 43087 | Barracuda | > | nextcloud/oc\_timetracker\_tag | 43088 | Barracuda | > | nextcloud/oc\_timetracker\_timeline | 43089 | Barracuda | > | nextcloud/oc\_timetracker\_timeline\_entry | 43090 | Barracuda | > | nextcloud/oc\_timetracker\_user\_to\_client | 43091 | Barracuda | > | nextcloud/oc\_timetracker\_user\_to\_project | 43092 | Barracuda | > | nextcloud/oc\_timetracker\_work\_interval | 43093 | Barracuda | > | nextcloud/oc\_timetracker\_workinterval\_to\_tag | 43094 | Barracuda | > | nextcloud/oc\_trusted\_servers | 43095 | Barracuda | > | nextcloud/oc\_twofactor\_backupcodes | 43096 | Barracuda | > | nextcloud/oc\_twofactor\_providers | 43097 | Barracuda | > | nextcloud/oc\_users | 43098 | Barracuda | > | nextcloud/oc\_users\_external | 43099 | Barracuda | > | nextcloud/oc\_vcategory | 43100 | Barracuda | > | nextcloud/oc\_vcategory\_to\_object | 43101 | Barracuda | > | nextcloud/oc\_weather\_city | 43102 | Barracuda | > | nextcloud/oc\_weather\_config | 43103 | Barracuda | > | nextcloud/oc\_whats\_new | 43104 | Barracuda | > ±----------------------------------------------------±------±------------+ > 220 rows in set (0.01 sec) ---
**Author:** ![AXCEL\_ANGE](https://help.nextcloud.com/user_avatar/help.nextcloud.com/axcel_ange/32/66284_2.png) [@AXCEL\_ANGE](https://help.nextcloud.com/u/AXCEL_ANGE)\ **Post date:** [February 19, 2020, 9:06am UTC](https://help.nextcloud.com/t/emojis-not-working/65004/2 "2020-02-19T09:06:43Z")
Hello ! 1- MariaDB [nextcloud]\> show variables like ‘innodb\_file\_format’; =\> Barracuda (ok) if you not, use: \*\* Mysql \> set global innodb\_file\_format=Barracuda ; \*\* 2- MariaDB [nextcloud]\> show variables like ‘innodb\_file\_per\_table’; =\> ON (ok) if you not ,use: \*\* Mysql \> set global innodb\_file\_per\_table=1; \*\* 3- MariaDB [nextcloud]\> show variables like ‘innodb\_large\_prefix’; =\> ON (ok) if you not ,use: \*\* Mysql \> set global innodb\_large\_prefix=on; \*\* and 4- MariaDB [(none)]\> SELECT NAME, SPACE, FILE\_FORMAT FROM INFORMATION\_SCHEMA.INNODB\_SYS\_TABLES WHERE NAME like “nextcloud%”; =\> All |Barracuda| (ok) if you not ,use: state 1-;2- and 3- 😉 ![image](https://help.nextcloud.com/uploads/default/original/3X/7/b/7b4aac2515337977dbe793657e60f6fccfe5fa8b.png) 5- Change your databases character set and collation: mysql\> ALTER DATABASE _name of nextcloud database_ CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci; For me: _name of nextcloud database_ is : db\_nextcloud 🤨 E.g: 🙃 mysql\> ALTER DATABASE db\_nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci; (ok) _/ P.S: Don’t restart mysql or mariadb /_🕶 6- Search apache user and occ directory on your configuration. For me : user apache= www-data occ directory= /var/www/html/nextcloud 😊 a) In directory _/var/www/html/nextcloud_ root@frommmage:~# cd /var/www/html/nextcloud ![image](https://help.nextcloud.com/uploads/default/original/3X/f/4/f4e74e106e6195b9f43b9ebefb48a251a5c6a9cc.png) b) List the content and find _occ_ root@frommmage:/var/www/html/nextcloud# ls ![image](https://help.nextcloud.com/uploads/default/original/3X/d/8/d80c41c8f79f7f31d5e64fd478dd835d91317ba1.png) c) Set the `mysql.utf8mb4` config to true in your config.php: root@frommmage:/var/www/html/nextcloud# sudo -u www-data php occ config:system: set mysql.utf8mb4 --type boolean --value=“true” ![image](https://help.nextcloud.com/uploads/default/original/3X/a/8/a8f245aaa7395248ab1beb435a7937deb00125b9.png) d) Convert all existing tables to the new collation by running the repair step: root@frommmage:/var/www/html/nextcloud# sudo -u www-data php occ maintenance:repair ![image](https://help.nextcloud.com/uploads/default/original/3X/2/0/201330afbddfae26368717b8f89441f532bd7a9d.png) Good! If you are: 😬 ![image](https://help.nextcloud.com/uploads/default/original/3X/3/7/37ca2650a0036efad74c17db1dcdbb5c46fc0656.png) use: a) # sudo -u apache php /var/www/html/nextcloud/occ maintenance:mode --on Option 1: 🥶🥱 Repeat the previous steps Option 2: 🧐 Following option 1 ![image](https://help.nextcloud.com/uploads/default/original/3X/3/9/3989e3c3338cd9ddda4bf7d53c6e3d325f02d378.png) root@frommmage:/var/www/html/nextcloud# sudo -u www-data php occ config:system:set mysql.utf8mb4 --type boolean --value=“true” root@frommmage:/var/www/html/nextcloud# sudo -u www-data php occ maintenance:repair b) # sudo -u apache php /var/www/html/nextcloud/occ maintenance:mode --off 🥳🤪 Test . 🤠🤡 👏👊 Source: 1- [https://docs.nextcloud.com/server/stable/admin\_manual/configuration\_database/mysql\_4byte\_support.html](https://docs.nextcloud.com/server/stable/admin_manual/configuration_database/mysql_4byte_support.html) 2-[https://stackoverflow.com/questions/10877410/error-while-restoring-mysql-db](https://stackoverflow.com/questions/10877410/error-while-restoring-mysql-db) Hello ! 1- MariaDB [nextcloud]\> show variables like ‘innodb\_file\_format’; =\> Barracuda (ok) if you not, use: \*\* Mysql \> set global innodb\_file\_format=Barracuda ; \*\* 2- MariaDB [nextcloud]\> show variables like ‘innodb\_file\_per\_table’; =\> ON (ok) if you not ,use: \*\* Mysql \> set global innodb\_file\_per\_table=1; \*\* 3- MariaDB [nextcloud]\> show variables like ‘innodb\_large\_prefix’; =\> ON (ok) if you not ,use: \*\* Mysql \> set global innodb\_large\_prefix=on; \*\* and 4- MariaDB [(none)]\> SELECT NAME, SPACE, FILE\_FORMAT FROM INFORMATION\_SCHEMA.INNODB\_SYS\_TABLES WHERE NAME like “nextcloud%”; =\> All |Barracuda| (ok) if you not ,use: state 1-;2- and 3- 😉 ![image](https://help.nextcloud.com/uploads/default/original/3X/7/b/7b4aac2515337977dbe793657e60f6fccfe5fa8b.png) 5- Change your databases character set and collation: mysql\> ALTER DATABASE _name of nextcloud database_ CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci; For me: _name of nextcloud database_ is : db\_nextcloud 🤨 E.g: 🙃 mysql\> ALTER DATABASE db\_nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4\_general\_ci; (ok) _/ P.S: Don’t restart mysql or mariadb /_🕶 6- Search apache user and occ directory on your configuration. For me : user apache= www-data occ directory= /var/www/html/nextcloud 😊 a) In directory _/var/www/html/nextcloud_ root@frommmage:~# cd /var/www/html/nextcloud ![image](https://help.nextcloud.com/uploads/default/original/3X/f/4/f4e74e106e6195b9f43b9ebefb48a251a5c6a9cc.png) b) List the content and find _occ_ root@frommmage:/var/www/html/nextcloud# ls ![image](https://help.nextcloud.com/uploads/default/original/3X/d/8/d80c41c8f79f7f31d5e64fd478dd835d91317ba1.png) c) Set the `mysql.utf8mb4` config to true in your config.php: root@frommmage:/var/www/html/nextcloud# sudo -u www-data php occ config:system: set mysql.utf8mb4 --type boolean --value=“true” ![image](https://help.nextcloud.com/uploads/default/original/3X/a/8/a8f245aaa7395248ab1beb435a7937deb00125b9.png) d) Convert all existing tables to the new collation by running the repair step: root@frommmage:/var/www/html/nextcloud# sudo -u www-data php occ maintenance:repair ![image](https://help.nextcloud.com/uploads/default/original/3X/2/0/201330afbddfae26368717b8f89441f532bd7a9d.png) Good! If you are: 😬 ![image](https://help.nextcloud.com/uploads/default/original/3X/3/7/37ca2650a0036efad74c17db1dcdbb5c46fc0656.png) use: a) # sudo -u apache php /var/www/html/nextcloud/occ maintenance:mode --on Option 1: 🥶🥱 Repeat the previous steps Option 2: 🧐 Following option 1 ![image](https://help.nextcloud.com/uploads/default/original/3X/3/9/3989e3c3338cd9ddda4bf7d53c6e3d325f02d378.png) root@frommmage:/var/www/html/nextcloud# sudo -u www-data php occ config:system:set mysql.utf8mb4 --type boolean --value=“true” root@frommmage:/var/www/html/nextcloud# sudo -u www-data php occ maintenance:repair b) # sudo -u apache php /var/www/html/nextcloud/occ maintenance:mode --off 🥳🤪 Test . 🤠🤡 👏👊 Source: 1- [https://docs.nextcloud.com/server/stable/admin\_manual/configuration\_database/mysql\_4byte\_support.html](https://docs.nextcloud.com/server/stable/admin_manual/configuration_database/mysql_4byte_support.html) 2-[https://stackoverflow.com/questions/10877410/error-while-restoring-mysql-db](https://stackoverflow.com/questions/10877410/error-while-restoring-mysql-db) ---
**Author:** ![Nobody](https://help.nextcloud.com/letter_avatar/nobody/32/5_5575768a8748004e209b776fc1b2916d.png) [@Nobody](https://help.nextcloud.com/u/Nobody)\ **Post date:** [March 11, 2020, 1:27pm UTC](https://help.nextcloud.com/t/emojis-not-working/65004/3 "2020-03-11T13:27:16Z")
I did everything. But still ??? on NC 18 ---
**Author:** ![GAPPSRefusenik](https://help.nextcloud.com/user_avatar/help.nextcloud.com/gappsrefusenik/32/23211_2.png) [@GAPPSRefusenik](https://help.nextcloud.com/u/GAPPSRefusenik)\ **Post date:** [April 2, 2020, 12:21am UTC](https://help.nextcloud.com/t/emojis-not-working/65004/4 "2020-04-02T00:21:54Z")
Same problem here. Did everything the documentation and the kind users here suggest. Just updated successfully to Nextcloud 18.0.3, and the issue persists. ---
**Author:** ![wwe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/wwe/32/72963_2.png) [@wwe](https://help.nextcloud.com/u/wwe)\ **Post date:** [December 4, 2024, 10:47am UTC](https://help.nextcloud.com/t/emojis-not-working/65004/5 "2024-12-04T10:47:14Z")
---
**Author:** ![wwe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/wwe/32/72963_2.png) [@wwe](https://help.nextcloud.com/u/wwe)\ **Post date:** [December 11, 2024, 4:02pm UTC](https://help.nextcloud.com/t/emojis-not-working/65004/6 "2024-12-11T16:02:45Z")