What is the best character set and collation for MySQL databases for Discord bot purposes?
Hello! As many people use MongoDB, I do know Mongo. However before you say to just use Mongo, I personally prefer MySQL and also this data will be used for other things that already use MySQL.
I currently have some database tables setup with the character set
utf8mb4 with the collation set to utf8mb4_unicode_ci. However even with the unicode collation, when someone uses an emoji or a like a chinese text character, the database errors and does not save most of the time. One of the main reasons why I use this specific character set and collation, is because as said before this data is used for other things such as: FiveM server, websites, multiple Discord bots, etc - so the goal is to keep it as universal as possible with what characters and text it can accept.
It may not be able to be perfect, but if anyone has any better suggestions than the one I am currently utilizing - I'd love to hear them. Thanks!2 Replies
Unknown User•16mo ago
Message Not Public
Sign In & Join Server To View
discord.js@14.7.1
node v18.12.1