How correctly import list and additional fields from external Mysql with charset-1251 ?

[verillo]

Hi!

I'm trying to import data from external Mysql. (About 20 columns in use).
The import is successful but I have problems with encoding in mysql (mailwizz)
Cyrillic words are displayed as ??? ????????

Can anyone suggest how to do the import from external mysql (encoding 1251) in mysql with utf-8 encoding

Thank you

 

[twisted1919]

Hi,

You need to make sure your data is utf-8, mailwizz can't really do any magic and convert it.
Your best bet is to make sure your external db should be utf-8 and correct any weird looking char sequence, then import it into mailwizz.

Thanks.

 

[frm.mwz]

Hi!

I'm trying to import data from external Mysql. (About 20 columns in use).
The import is successful but I have problems with encoding in mysql (mailwizz)
Cyrillic words are displayed as ??? ????????

Can anyone suggest how to do the import from external mysql (encoding 1251) in mysql with utf-8 encoding

Thank you

go into phpMyAdmin re old sql database
look at the structure and change collation to
utf8_unicode_ci
save it
then export/import