phpMyAdmin and latin1_swedish_ci
11,992
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.
Comments
-
Gavrisimo almost 2 years
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: