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.

Share:
11,992
Gavrisimo
Author by

Gavrisimo

Web developer wonna be!http://www.arvag.net

Updated on June 04, 2022

Comments

  • Gavrisimo
    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:

    alt text

    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":

    alt text

    This is how it looks like when i am creating new database:

    alt text