Opened 4 years ago

Closed 4 years ago

#5276 closed defect (bug) (fixed)

Emoji not working on

Reported by: johnjamesjacoby's profile johnjamesjacoby Owned by: dd32's profile dd32
Milestone: Priority: normal
Component: Keywords: needs-testing


Just noticed that emoji show up as ???? on

Maybe related to r9949, or maybe they simply never worked and nobody tried until now.


Change History (3)

#1 @dd32
4 years ago

  • Status changed from assigned to accepted

#2 @dd32
4 years ago

This appears to be because the database tables are utf8 and not latin1 or utf8mb4 which support Emoji's.

So no, Emoji's didn't previously work as far as I can tell :)
I've also tried to force it, and it just doesn't save no matter what the collations are set to.

Looks like the best option forward here would be to perform the utf8->utf8mb4 upgrade for the appropriate tables. There's a bunch of sites on where the table collation are latin1 too, but they can probably be skipped.

r9949 was superseded by a change made directly in's HyperDB configuration.

#3 @dd32
4 years ago

  • Resolution set to fixed
  • Status changed from accepted to closed

Did the conversion to utf8mb4 for the utf8 tables.

Example thread for those with access:

See also #1914

Note: See TracTickets for help on using tickets.