Problem with phpMyAdmin database collation
Posted by: Alexander_Ukraine (195.128.139.---)
Date: February 20, 2018 04:17AM

Hello everyone!

I have installed:

Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.2.2/7.1.14/7.0.27/5.6.33 - MySQL 5.7.21 - MariaDB 10.2.12.


I create a blog on WordPress without any code-changes. Just WordPress and common plugins. After the instalation of Wampserver 3.1.1 I've realized that something went wrong. All widgets' titles were broken in the setting panel. I use russin version of WordPress and some widget settings do not display correctly.

I think the problem is in MySQL with charset latin1_swedish_ci. I need utf8_general_ci. I have created new database with utf8 and I have changed the main MySQL data base and all tables latin1_swedish_ci into utf8_general_ci. But it doesn't help.

Does anyone have some ideas on how to display russian language correctly?

PS. I don't understand anything in computer codes. And Idon't gonna stuck my nose into them. I'm just a philologist smiling smiley

Options: ReplyQuote
Re: Problem with phpMyAdmin database collation
Posted by: RiggsFolly (Moderator)
Date: February 20, 2018 10:03AM

It sounds like you should ask this of the WordPress community, there are no WordPress experts here

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (Wampserver 3.1.3 32bit & 64bit)
<Apache 2.4.29/2.2.31> <PHP 7.2/7.1/7.0/5.6/5.5/5.4> <MySQL 5.7.19/5.6.39/5.5.28>
<MariaDB 10.2.14> <phpMyAdmin4.8.1> <MySQL Workbench 6.3.10>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Problem with phpMyAdmin database collation
Posted by: Alexander_Ukraine (195.128.139.---)
Date: February 20, 2018 12:33PM

Oh really? Although yes ... Only Wordpress has an encoding of the database . Excuse for troubling. You helped me a lot.

Options: ReplyQuote
Re: Problem with phpMyAdmin database collation
Posted by: Otomatic (Moderator)
Date: February 20, 2018 03:35PM

Hi,

Wampserver in the my.ini files of MySQL or MariaDB does not define any default charset.

It is up to WEB applications and CMS's to define the appropriate charset when creating databases.
If applications rely on the default charset, without even checking if it exists or if it's the right one, it's their problem, not the Wampserver one.

This is in no way the responsibility of Wampserver.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.3 32 bit - Apache 2.4.33 - PHP 7.2.5/7.1.17/7.0.30/5.6.36 - MySQL 5.7.22 - MariaDB 10.2.15
Wampserver 3.1.3 64 bit - Apache 2.4.33 - PHP 7.2.5/7.1.17/7.0.30/5.6.36 - MySQL 5.7.22 - MariaDB 10.2.15
PhPMyAdmin 4.8.0.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.