On both my local (Windows) machine and live server (Linux) there is a table set up as InnoDB with utf8mb4_unicode_520_ci collation. The column is a varchar. Sometimes the text enterred in the field contains the UK Pound symbol (e.g. Reduced to £6 for one week).
If the text is displayed using webpage on my localhost the pound sign displays correctly. From the live server the replacement character (diamond with question mark) displays. On both systems the pound sign entered as text in HTML page displays correctly. All HTML/PHP pages have the <meta charset="UTF-8">.

All tables in both databases are set up InnoDB and the same collation. However have noticed that on the local database PHPMyAdmin shows the default storage to be MyISAM, wheras on the Linux server it is InnoDB.

I find this strange as the database and tables were set up on the local PC, then exported to a SQL file which was used to create the database on the Linux server.

I was wondering if this was the problem, but cannot see a way to change it using PHPMyAdmin on either the local PHPMyAdmin or the server’s cPanel version of PHPMyAdmin.

I have seen other similat questions where the reponse has been to go onto PHPMyAdmin then variables … but there is no variables option on either version of PHPMyAdmin I am using.