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

Update the MySQL collation to default #35

Open
mvl22 opened this issue Sep 30, 2022 · 2 comments
Open

Update the MySQL collation to default #35

mvl22 opened this issue Sep 30, 2022 · 2 comments

Comments

@mvl22
Copy link
Member

mvl22 commented Sep 30, 2022

We should update
collation-server = utf8mb4_unicode_ci
to
collation-server = utf8mb4_0900_ai_ci

https://github.com/cyclestreets/cyclestreets-setup/blob/master/utility/installBaseWebserver.sh#L211
@mvl22 mvl22 mentioned this issue Feb 19, 2023
Open
@si-the-pie
Copy link
Member

Explanation of the parts of the collation name at:

https://stackoverflow.com/a/9531221/225876

It also lists some ideas for generating all the SQL commands required to change a database.

@mvl22
Copy link
Member Author

mvl22 commented Mar 3, 2023

Fixed in 3f684d5, which will mean MySQL now uses the default.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@mvl22 @si-the-pie