Thank you for this – first I updated the code to say ‘DB_CHARSET’, ‘utf8_unicode_ci’); which sorted out about half the symbols and then I used the following to find and replace the rest:
https://www.ads-software.com/extend/plugins/search-and-replace/