Can’t INSERT "DROP TABLE 😎"

future-application-laboratory / BirthReminder

The tool that helps you manage your favorite ACGN characters’ birthdays

https://birthreminder.fal.moe

GNU Affero General Public License v3.0

18 stars 2 forks source link

Can’t INSERT "DROP TABLE 😎" #13

Closed ApolloZhu closed 6 years ago

ApolloZhu commented 6 years ago

WHERE IS Unicode support?

uetcis commented 6 years ago

Well, I've got no idea with this bug. According to the log file on my backend, there seem to be something wrong with the MySQL insertion, and I'm wondering if this is a bug of PerfectMySQL.

uetcis commented 6 years ago

Also, if you're interested in it, you may check out the backend for further.

uetcis commented 6 years ago

Issue resolved by setting the charset to utf8mb4 in MySQL ref: https://blog.csdn.net/u013145194/article/details/51527389