CODEWITHSUNDEEP
sqlmysqlphpmyadmincollation
Gavrisimo
Gavrisimo

Reputation: 1837

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

Upvotes: 4

Views: 12685

Answers (2)

Arpit Tambi
Arpit Tambi

Reputation: 1194

goto phpMyAdmin's folder look for config.inc.php. Open it and search for 'collation', probably arnd line 370 - change it to -

$cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci';

Upvotes: 0

Dooltaz
Dooltaz

Reputation: 2463

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.

Upvotes: 2

Related Questions