Database Collation causing case insensitive comparison.

ValkyrjaProject / Valkyrja.core

[C# - netcore] Community Management bot for Discord (Core library)

https://valkyrja.app

MIT License

11 stars 6 forks source link

Database Collation causing case insensitive comparison. #64

Open RheaAyase opened 6 years ago

RheaAyase commented 6 years ago

I don't know if we can solve this problem because our bigger concern is having UTF8 support for emojis, and UTF8 does not seem to have any _cs options.

Needs more research...

Venefilyn commented 6 years ago

It seems MySQL has implemented case-sensitive utf8mb4 collations with utf8mb4_0900_as_cs, though it is not available on MariaDB, nor is there any news on their Jira tracker about it.

Only way I can see us implementing this is either going to MySQL, or migrating to PostgreSQL which is case-sensitive out of the box and allegedly supports unicode very well, meaning emojis can be added.