Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Database Collation causing case insensitive comparison. #64

Open
RheaAyase opened this issue Nov 7, 2018 · 1 comment
Open

Database Collation causing case insensitive comparison. #64

RheaAyase opened this issue Nov 7, 2018 · 1 comment
Assignees
@Venefilyn @RheaAyase
Labels
1 - High Priority bug help wanted

Comments

@RheaAyase
Copy link
Member

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
Copy link
Member

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Venefilyn Venefilyn

@RheaAyase RheaAyase

Labels
1 - High Priority bug help wanted
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@Venefilyn @RheaAyase