Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

phpMyAdmin and latin1_swedish_ci

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

like image 283
Gavrisimo Avatar asked Nov 20 '25 14:11

Gavrisimo


1 Answers

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.

like image 109
Dooltaz Avatar answered Nov 23 '25 03:11

Dooltaz