D4R4/unicode_mysql

Created March 13, 2019 17:59

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/D4R4/ea223329f549b7f3a3f6897179a86eb1.js"></script>
Save D4R4/ea223329f549b7f3a3f6897179a86eb1 to your computer and use it in GitHub Desktop.

Download ZIP

For some reason altering table from editor GUI did not solve the error, meanwhile this did the trick,

Raw

unicode_mysql

ALTER TABLE countries CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

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