I create new database with utf8_general_ci collation, create test table also with utf8_general_ci collation, and then i click on my database(structure) and this is what i get:
Why is that "latin1_swedish_ci" showing up?
Edit:
Ok how to change this, it is in phpmyadmin in "Variables" tab, under "Server variables and settings":
This is how it looks like when i am creating new database:
Usually collation problems will cause your queries to run exceedingly slow, so it's important that everything is setup properly.
You have a database connection collation, a database collation and a table collation. Be sure all three are setup to utf8. If the problem persists, check your phpmyadmin configuration file and see what collation defaults are showing up.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With