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

verillo

New Member
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

Administrator
Staff member
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

Well-Known Member
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

;)
 
Top