0

I'm trying to migrate a site to WordPress. The site is in Portuguese. The original site database contains Portuguese words. I can view the word 'Alérgicos' as 'Alérgicos' in the database via phpMyAdmin. But in site the same word is viewed as 'Alérgicos'.

Using WordPress functions I'm importing this data to the database of new site. Now in wp_terms table the word entering is exactly ' Alérgicos'. And in browser it is appearing as same 'Alérgicos'. So how can I change the display to 'Alérgicos' or how can I convert 'Alérgicos' to 'Alérgicos' during new db insert?

halfer
  • 19,824
  • 17
  • 99
  • 186
sreelakshmi
  • 264
  • 4
  • 18
  • what are `charset` and `collate` in old and new databases? – Samvel Aleqsanyan Feb 09 '18 at 10:06
  • @SamvelAleqsanyan old database - utf8 and utf8_general_ci . For the new Db it was utf8mb4 and utf8mb4_unicode_ci. I tried to change it. But it didn't worked – sreelakshmi Feb 09 '18 at 10:11
  • @sree you can't just change it after it's already imported. You need it to be correct before you bring over the data. – Dave Feb 09 '18 at 14:58
  • 1
    See "Mojibake" in https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored – Rick James Feb 09 '18 at 16:42

0 Answers0