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.

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

Alternative version using utf8mb4 #7

Closed
Synchro opened this issue Apr 3, 2013 · 1 comment
Closed

Alternative version using utf8mb4 #7

Synchro opened this issue Apr 3, 2013 · 1 comment

Comments

@Synchro
Copy link
Contributor

Synchro commented Apr 3, 2013

I'd started using the original version, but then found out that what MySQL thinks is UTF-8 is actually just a subset, specifically, that it doesn't support 4-byte characters, only 3. I've made a variant in a separate branch that defaults to using this charset. There's a good article on it here.
Of course most people won't need that full range - it includes some lesser-used Chinese characters, but more interestingly it includes full-colour Emoji icons that work in OS X and iOS, oh, and GitHub 😸!
Another minor difference is that it's using the 'utf8mb4_unicode_ci' collation, which is more correct than the default 'utf8mb4_general_ci', and results in correct sort orders in German and other languages.

@nicjansma
Copy link
Owner

Super, I wasn't even aware of utf8mb4.

If you want, it would be nice if the script was updated to prompt the user to choose either utf8 (if they don't have MySQL 5.5.3) or utf8mb4 if they do, then use that setting for the rest of the variables.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants