PhpMyAdmin and latin1_swedish_ci

I create a new database with utf8_general_ci mapping, create a test table also with utf8_general_ci mapping, and then click on my database (structure), and this is what I get:

alt text

Why does this "latin1_swedish_ci" appear?

Edit:

Well, how to change this, this is in phpmyadmin on the "Variables" tab in the "Variables and server settings" section:

alt text

Here's what it looks like when I create a new database:

alt text

+3
source share
2 answers

Typically, sorting problems will make your queries run very slowly, so it’s important that everything is set up correctly.

, . , utf8. , phpmyadmin , .

+1

phpMyAdmin goto config.inc.php. "", , arnd 370 - -

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

Source: https://habr.com/ru/post/1717460/


All Articles