cannot upload a file called 🌍.csv (or similar)

this bug was created many years ago. I guess it’s been fixed under a different ticket

This works for me locally under these conditions:

• Created a fresh (mysql) database using the utf8mb4 character set.

• Set the following props in sakai.properties (as instructed from ):

  • driverClassName@javax.sql.BaseDataSource=com.mysql.cj.jdbc.Driver
    hibernate.dialect=org.hibernate.dialect.MySQL8Dialect
    url@javax.sql.BaseDataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8&useSSL=false
    content.cleaner.filter.utf8=false

So, it seems like the application will support it just fine, you just have to convince the database!

I don’t know exactly how the nightly servers are configured with respect to the databases, but this doesn’t work on the mariadb or mysql8 instances. Oracle instance is currently down, so can’t test it at all.

Locally, I got this in the logs:

Note that this seems to affect a file with any emoji in the title, it is not specific to the globe emoji