Problems with encoding and Doctrine

Question

PHP

Hello
, I have come across this situation.
We have:
1. Hosting with database. Encoding utf ( d.pr/i/CBSU )
2. Hosting with a project on Silex that accesses the database on hosting #1.
DB connection uses charset - UTF
On the output page charset - UTF.
However, when fetchAll from the database, we get Cyrillic data in the form: �� ��������� d.pr/i/zzGi
For correct display, we have to do:
$data = iconv("Windows-1251", "UTF-8", $data);
Any advice?

Answer 1

The fact that phpmyadmin tables are encoded in utf-8 does not mean that there is really utf-8 inside. I once dumped the database in a similar situation, converted it to utf-8 and poured it back.

Answer 2

set names 'utf-8'