Problem with UTF-8 encoding

[thehurricane]

Hello,

I have problem with polish characters. In admin area on customers list polish characetrs aren't showing. In attachment screenshot. On front everything is ok, on other places in admin area too. Only customer list. Any1 had similar problem??

 

 

Edited August 4, 2023 by thehurricane (see edit history)

[Knowband Plugins]

try changing the  firstname, lastname Collation of DB columns in customers table  to "utf8_general_ci" using phpmyadmin.

 

 

[thehurricane]

On 3/18/2020 at 1:11 PM, Knowband Plugins said:

try changing the  firstname, lastname Collation of DB columns in customers table  to "utf8_general_ci" using phpmyadmin.

 

 

done and nothing changed

[vmthang]

On 3/17/2020 at 10:32 AM, thehurricane said:

Hello,

I have problem with polish characters. In admin area on customers list polish characetrs aren't showing. In attachment screenshot. On front everything is ok, on other places in admin area too. Only customer list. Any1 had similar problem??

 

I have the same problem. Did you manage to fix this? I believe this is a problem with MySQL server encoding? Are you using Home server?

[ComGrafPL]

I would personally ask a hosting provider to check it out.

[ebela]

Hello, i found a solution.

You can add "SET NAMES utf8mb4" to doctrine yaml configm or extend the current INIT_COMMAND.

#app/config/doctrine.yml 

	options:
		# PDO::MYSQL_ATTR_INIT_COMMAND
		1002: "SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')), names utf8mb4"